Hi
I'm new to this stuff, so please excuse my naiveté.
I receive a daily file consisting of sales records. Unfortunately, the file isn't just new sales but rather it's a cumulative file including all previous sales. The file does not contain a date field (don't ask why!), and is sorted in such a way that the new records are not obvious.
Is there a way for me, a newbie, to compare the 2 files (yesterday's to today's) so that I can identify the new records?
I'm trying to borrow this formula from a post by NBVC to compare two different spreadsheets to see if a record in one (all related columns) appears exactly in another spreadsheet.
{REMOVED NBVC's borrowed formula as he replied to another post stating that my search type didn't meet the criteria for using MATCH). :-(
I found DAVESEXEL's formula that I modified...
=IF(COUNTIF([Sample1.xls]Sheet1!$A$2:$G$1000,Sheet1!A2:G2)=0,"Unique","") This isn't working.
Am I on the right track or is some other approach better? Still trying to search for more existing posts.
Thanks!
Uploaded sample files.
SAMPLE1 has 2 records that also appear in SAMPLE2. SAMPLE2 had a 3rd record which is uniqie. How can I compare the two files so that I can find unique records?
Bookmarks