| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to create a check list with a count of entries at bottom. | Excel Worksheet Functions | |||
| Check for duplicate entries in pull-down list | Excel Discussion (Misc queries) | |||
| check a list of numbers for duplicate entries in Excel | Excel Discussion (Misc queries) | |||
| Check for double entries in a row | Excel Worksheet Functions | |||
| How do I search a mailing list spreadsheet to remove entries alre. | Excel Discussion (Misc queries) | |||
Linear Mode
