| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif on zip codes that vary in format
A Zip Code list may contain: 12345 and 12345-6789 and 123456789
The reference cell "D1" on a seperate sheet = 12345 I want to know the number of occurances of the value in "D1" in the Zip Code List and I need to fill down 1800 rows (D1 to D1800) with the formula. =COUNTIF('10 yrs'!I:I,D1) returns a count of 12345 within the list but does not capture the occurance of 12345 within the other longer strings. I cannot seem to add a wildcard to the "D1" value. Any thought on how I can get there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to format varying zip codes... | Excel Worksheet Functions | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| Vary the criteria in countif | Excel Discussion (Misc queries) | |||
| how to format zip codes | Excel Discussion (Misc queries) | |||
| I am not able to format cells for zip codes | Excel Worksheet Functions | |||
Threaded Mode
