PDA

View Full Version : Solved: Compare 2 spreadsheets



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

mancubus
09-04-2012, 02:11 AM
hi,

you can use a helper column, say column Z, in Sheet2 (bigger list) and use below formula.

=COUNTIF(Sheet1!$A$1:$A$15000,A2)
in Z2 and copied down.

then filter "0"s in helper column to see values in Column A which do not exist in Sheet1 (smaller list).

Blackie50
09-04-2012, 03:42 AM
thanks for your help - works fine

regards

mancubus
09-04-2012, 05:49 AM
you're wellcome.