Check Spreadsheet entries against a list
 

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.

Check Spreadsheet entries against a list
 

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

"SarahJ" wrote:

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.