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

  1. vasim

    Index small if row (match if begins with....

    Awesome........only one word.....PERFECT......thanks
  2. vasim

    Index small if row (match if begins with....

    Thanks Faseeh, the list entries present 1)AA-BBC & 2)BBC-AA for the lookup value as AA, however I was looking to get only AA-BBC & not BBC-AA as AA-BBC starts with AA (then the second match that starts with AA), whereas BBC-AA starts with BB and not the lookup value (AA)..... (EDIT Added - to...
  3. vasim

    Index small if row (match if begins with....

    Thanks Faseeh....From the two questions, for the second this is exactly what I was looking for... This can be used for "contains".....any idea how can we incorporate for "begins with" ..... THANKS AGAIN...
  4. vasim

    Index small if row (match if begins with....

    In the formula =Index(range1,small(if(range2=cell,row(range2)),row()) when dragged gives me the first cell match, second cell match & so on.... is it possible to get match that begins with or contains...something like =Index(range1,small(if(range2=cell&"*",row(range2)),row())...
  5. vasim

    Unique values from range UDF

    Perfect....Narayan Thanks Small Man thanks but I was looking for a UDF EDITED (SirJB7) Whenever you reply a post, take care of writing the new text off the quoted section: [ QUOTE ] [ / QUOTE ]
  6. vasim

    Unique values from range UDF

    Hi Friends, I have three range of data, lets say C2:C40, E2:E40, G2:G30 through some formula this range gets populated (a few cells goes as blank ""). I was wondering if someone can help me get some UDF (again UDF) to get the unique values from this range in I2:I40... Image link...
  7. vasim

    Thinking.... :)

    Thinking.... :)
  8. vasim

    How to run a loop based on the len value in the cell [SOLVED]

    For i = 1 to worksheetname.range("C1").value If you post some code maybe you can get further assistance from Ninja's
  9. vasim

    Dashboard or RAG Idea

    Firstly, this isn't exactly an excel question but related to help in creating a RAG/Dashboard stuff in excel. Background: The boss just called me in and explained the following - We have plans to migrate some work from onshore for which we will be hiring candidates. We have the actual...
  10. vasim

    GETPIVOTDATA formula to identified FILTER from slicer

    May be you can apply the same criteria in the pivot as well in the "Report filter option" and give an = sign Depending on it....
  11. vasim

    Excel aptitude test inside a workbook

    Kudos...I loved solving them (Don't know why)
  12. vasim

    Updated Post - Please Read

    The big challenge is we are using an outdated version of forum software. We cant update it as the developers abandoned bbpress almost 2 years ago. +1 Definitely need a change...and if you are changing...please have a thanks or like or +1 added to it....please I beg :(
  13. vasim

    Assigning named workbook ranges to VBA variable (Excel 2007)

    Try Activeworkbook.names.range("your range")
  14. vasim

    Congratulations NARAYANK991 4,000 Posts

    CONGO NARAYAN...... Narayan...Narayan....:)
  15. vasim

    Display image on the base of cell value in the validation list

    Just because you appreciated my username... don't know give it out a try... https://docs.google.com/file/d/0B0kxdNrvyzqzVzRxQ3VaUDg2aEk/edit?usp=sharing
Back
Top