• 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 to Understand what this formula is exactly doing

    Hi Vijay, here is the data file with the formula in column B and Data in Column A, It will great help if you can decipher the formula.
  2. sanmaya

    Need Smooth VBA Code for the Output i want.

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

    Variable Tables in Dashboards

    Hi u can use scrollbar option for your table data to show in dashboard.
  4. 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 .
  5. 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})))
  6. 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
  7. 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...
  8. sanmaya

    how to unhide group of sheets in a workbook.

    Thanks a lot to you all for your support and help. i used the LUKEM's Code and assigned a key to it and it is working perfectly. Thanks once again.
  9. sanmaya

    how to unhide group of sheets in a workbook.

    Thanks Bobhc and Faseeh, i know this process, but i want to unhide all the sheets which are hidden all at once, i mean in one go.
  10. 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.
  11. sanmaya

    Hello .. Introduce yourself

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