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...