• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. sanmaya

    Need Smooth VBA Code for the Output i want.

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

    Need to Understand what this formula is exactly doing

    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})))
  3. sanmaya

    I Need a code to know the row number from which the filter data is been shown.

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

    Need Help in VBA for my scenario in Excel

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

    how to unhide group of sheets in a workbook.

    hi all, do anybody know how to unhide a group of worksheet all at once? please let me know the process.
Back
Top