Check Spreadsheet entries against a list

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.
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting a cell value 2
Excel does not accept text format! 0
Help with Formula 4
Using Forms in my spreadsheet 3
Email notifications without opening application 1
Links between worksheets in Excel 07 1
Multiple entries query 6
Recover Outlook calendar entry 1

Top