Check Spreadsheet entries against a list

  • Thread starter Thread starter SarahJ
  • Start date Start date
S

SarahJ

I have Spreadsheet A information regarding our products and the counties the
products are offered in. I have another Spreadsheet B with all of the
counties in the state. How do I go about finding out which counties are not
listed on Spreadsheet A.
 
Hi,

In sheet B beside each county enter the formula =COUNTIF(A1,SheetA!B$1:B$1000)

where A1 is a cell with a county and B1:B1000 are all the counties listed on
the other sheets. Fill the formula down. If the value is 0 the item was not
found on the other sheet.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top