Search results

Awesome........only one word.....PERFECT......thanks

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

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

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

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 ]

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

Thinking.... :)

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

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

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

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

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 :(

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

CONGO NARAYAN...... Narayan...Narayan....:)

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

JAHAPANHA TUSSI GREAT HO.....TOHFA QABOOL KARO..... A famous Indian movie (3 Idiots) dialogue......which means..... Emperor you are great..please accept the gift... PS:- Watch it on youtube if unclear.....:)

You may want to have a look at the Camera tool excel option.....just google it

Thanks Hui...as usual...on the spot.... rwb has some macro on opening..... Thanks Vijay as well...

Hi, I am testing the below code through F8 option, however each time I reach on Workbooks.open the further code runs automatically (without pressing F8) and ends... Any ideas....I want to go through F8 F8 to check in each of the workbook. Sub update() Dim myfolder, myfile As Variant Dim...

Thanks Faseeh, I changed up my mind...prepared a Pivot, used offset to define range, and used the named range as formula, to populate table... Thanks

INDEX('Report'!$B$1:$B$25000,SMALL(IF(('Report'!$M$1:$M$25000="Health")*('Report'!$P$1:$P$25000="Open"),ROW('Report'!$B$1:$B$25000)),ROW())) I want to add an or condition wherby, if in P col is Accept as well - taken in account. any help please. something like...

Thanks Luke... We have agreed to scrap this part, (the filter one). Anyways thanks for again reminding me to think Out of Box - in Excel atleast.

CONGRATS SIR

Hi Please dont beat me for asking this. I have a lot of data, with the help of chandoo highlight series link, I’m able to get the count within the data for parameter on which mouse is rolled. However I would also like to filter the actual data based on mouse rollover, something like Public...

Thanks Colin Legg....you are on the spot......I have Excel 2007....and from whom I received the file has Excel 2010.... THANKS..... I hv gone back saying I require a higher version...