Hello to all,
I have an original list like this: list1.xlsx
NAME CODE CASH
Mike 6001 $15
Anna 3405 $6
Jim 4582
Mary 8482 $7
John 2567
Tom 7234 $2
and after I remove the rows with blank CASH cells and I sort by CODE I get this and save as: list2.xlsx
NAME CODE CASH
Anna 3405 $6
Mike 6001 $15
Tom 7234 $2
Mary 8482 $7
Now, how can I auto-check if NAME has the right CODE NUMER and CASH next to it?
How can I compare list1.xlsx and list2.xlsx and be sure that Mike has next to him 6001 and 15, then Tom etc etc so that I am sure that I haven't screwed up things by a mistaken edit?
Bookmarks