Search/Match

[gkhnr10]

Hi there,

I run a report every week with a list of 1000 different names and rankings. You can imagine a sort of Top 1000 list that every week changes. One of my functions is to search new companies that get into Top 1000 list every week. I am not interested to see difference of rankings of the same company between two weeks. What I am interested basically is to identify new companies that get into the list, the ones that were not in the last week list. The difficult part is to check whole list every week, copy and paste every name to see if they were in the last week list or not.

I want to create an excel sheet like attached one. The subject is to take the data in E2 , search the company name between B2 and B11, if the company is in the list of week 10th, type the ranking in G2, if the company is a new one which was not in the last list, type in correspondent G cell NEW. As you see some companies keep in the list and some of them drop down. [B][B]The only important thing is to identify new ones

I hope I could explain it clear enough. I highly appreciate if you guys download the attached excel sheet, take a look and let me know your opinion about possible ways to get this issue solved.

Thanks you beforehand.

Sincerely.

Gokhan.

Example Top 10.xlsx

[micope21]

Hi

Cell G2

Please Login or Register  to view this content.

Copy down.

This only work Excel 2007 to 2013

Is this what you looking for?

Regard
micope21

[gkhnr10]

This has worked 100%. Thank you very much for your quick response, you are a hero

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[gkhnr10]

Hi ,

Thank you for making me aware of some of forum rules. I marked the topic as solved and added reputation. I will keep those in mind for future topics.

Gokhan