D
Don
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?
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?