Smallman, Thanks for your Idea,
But if you carefully see the Output data, i need the 12 months number as header, and that cant not be possible with pivot.
the code should just put the products qty in respective months.
Hi All,
i need a VBA code for the output i need.
Please find the attached sample data file for your reference. this data file have two tabs, input and output.
input tab contains the data and output tab have the output for the input data.
Thanks .
Hi all,
can any one please elaborate what this formula is exactly doing.
=-LOOKUP(0,-LEFT(W2,ROW(INDEX(W:W,1):INDEX(W:W,LEN(W21)))))&" "&-LOOKUP(1,-(" "&RIGHT(SUBSTITUTE(SUBSTITUTE(W2,")",""),"E","X"),{1,2,3,4,5,6,7,8,9,10,11,12})))
HI All,
can anybody help me in this issue.
i need a a vba code which will tell me the row no from which the filter data is been shown in the sheet.
Thanks
Hi all,
i have sheet in which the 68th column having title type and column 69 to 72 are columns which contains vlookup formula in their cell. the sheet have 50000 rows. the type column have three values in it "YES" , "NO" and blank cells. i want to remove the rows in which the type column cell...
Hi all,
i am sanmaya and today i joined chandoo.org, i was following the blog of chandoo.org a sometime before. i joined here to sharp my skill with excel. hope here i will get good knowledge.