Hi
I have two spreadsheets. They have virtually the same data however one has 256 records more than another. I need to see what these extra records are. However there are approximately 10000 records in each spreadsheet so it is impossible for me to tell. Is there some kind of filter or function that I can run to just display those records that are in a second spreadsheet which are not in the first?
I have tried putting both sets of records into one big spreadsheet (so there are 20000 records in total and many duplicates of course) and filter out unique records using advance filter but this is not helping.
Please can anyone assist with this problem?
Thank you very much for any help.
Les
I have two spreadsheets. They have virtually the same data however one has 256 records more than another. I need to see what these extra records are. However there are approximately 10000 records in each spreadsheet so it is impossible for me to tell. Is there some kind of filter or function that I can run to just display those records that are in a second spreadsheet which are not in the first?
I have tried putting both sets of records into one big spreadsheet (so there are 20000 records in total and many duplicates of course) and filter out unique records using advance filter but this is not helping.
Please can anyone assist with this problem?
Thank you very much for any help.
Les