Question on comparing multiple columns to a master column

M

madlinux

I have a column in a spreadsheet that contains a list of all the
packages that exist in a folder that is replicated to 15 different
servers around the world. Now I am looking to see if the physical
directories match the list. So far I have used the formula
=IF(COUNTIF(A:A,B2)=0,B2,"") to compare the master column with the
column that lists the physical directories on the servers folder.

I now have a spreadsheet with 15 columns representing the missing files
for each server when compared to the master list.

I now am trying to see if there is a way to compare all of the columns
with the missing packages to each other so that I can produce a column
that shows which package all of them are missing and excludes the ones
that are not found in each column.

I know that the long way to do this would be to use my existing formula
over and over again on all the columns against the other columns and
then come up with the result I want but I am thinking to be precise I
will have to do this 225 times!

Can anybody tell me if there is a easier way to do this? I don't want
the work done for me but a general direction in which way I should go
would be nice.
 
Top