Comparing changing Data

[Russ]

Hi folks,

I need to compare data on a weekly basis. The problem is that new entries or
unique identifiers are also created every week. So if I sort it by name, the
list never matches cause new entries are there. How do i match new values
when the list adds on new entries?

Russ

 

[Max]

Believe index/match would serve your intents (the data need not be sorted)
For starters, try Debra Dalgleish's nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's also some sample workbooks available for d/l & study