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

Recent content by nicholes

  1. N

    how to do the same in another workbook? file attached

    I know i am asking tooo much ... please tell me how do i filter specific name with one click ? for example i want to filter "Mr.x" with one click Or how d i make a button to filter a specific name?
  2. N

    how to do the same in another workbook? file attached

    Thanks. that works like i want... you really deserve "like" for each of post or comments and help Thanks again. CHEERS......
  3. N

    how to do the same in another workbook? file attached

    That works now Thankyou very much can you tell me how do i make one button to check all boxes in filter (for A colomn )
  4. N

    how to do the same in another workbook? file attached

    WOOOOOOOOOOOWWWWWWW thats working now Thanks a million
  5. N

    how to do the same in another workbook? file attached

    Ooops just updated
  6. N

    how to do the same in another workbook? file attached

    It actually filter using a text box appearing after clicking on the button instead of dropdown box (inbuilt filter) and check box for filtering the data, I have two files one is working and another one is in which i want to do the same. i filter the data using some vba code(someone did it for...
  7. N

    filter by using hyperlink or search box instead of checking boxes

    thanks
  8. N

    filter by using hyperlink or search box instead of checking boxes

    i am using excel 2007 and i dont find advance filter please tell me if i am wrong i have also attached sample file
  9. N

    filter by using hyperlink or search box instead of checking boxes

    i have too many customers and i filter them by checking the boxes(when we filter data) but now since they are now too many i want to make it easy and filter them by just tying thier name in some ind of search box or some kind of hyperlink or anything which can filter data easily
  10. N

    Welcome Ramazan Karim!!

    Hi faseeh ramzan mubarak! you helped me in my thread almoast one year back. you are my hero !!!!
  11. N

    how do i AUTOSUM cells contains formulas in it?

    it worked THANKS luke.
  12. N

    how do i AUTOSUM cells contains formulas in it?

    i have to autosum a column but it has formulas in it =INDEX(Sheet2!L5:L24,MATCH(nuru!B5,Sheet2!M5:M24,0),0) i want autosum it i get error #N/A how can i get autosum???
  13. N

    Indexmatch very simple formula needed help plz(screenshot attached)

    =IF(B3:B13=$L$1,A3:A13,"") i have got this simple formula but it leaves spaces when customer name does not comes (L1 is customer name's cell)
  14. N

    Indexmatch very simple formula needed help plz(screenshot attached)

    is it possible to use different formula for each column? i dont want to use array formula, also it hard to understand how it works.
  15. N

    Indexmatch very simple formula needed help plz(screenshot attached)

    Hi, faseeh i was just looking at the formula by selecting random cell and click in formula bar and when i click outside the cell ,the cell goes blank! it is happening every time in each cell when i click in formula bar. what actually i have noticed, whenever i click in formula bar and click...
See more
Back
Top