Blackie50
09-04-2012, 01:10 AM
Hi,
I have a spreadsheet with a list of account numbers (column A). I have another sheet with a bigger list of account numbers that includes the original list (still column A).
Is there any quick way to compare the 2 and come up with just the additional entries on the bigger list either on a seperate sheet or shading them on the bigger lsit?
many thanks
Jon
I have a spreadsheet with a list of account numbers (column A). I have another sheet with a bigger list of account numbers that includes the original list (still column A).
Is there any quick way to compare the 2 and come up with just the additional entries on the bigger list either on a seperate sheet or shading them on the bigger lsit?
many thanks
Jon