I have an array of cells that have a "complex" value in each cell.
The values have the following format:
4 numbers, a dash, and a 3 digit alpha numeric.
Examples would be such as : 9103-V32, 2205-133, 4455-AB6, etc ...
Need to have the ability to find the number of times the 4 digit values occur in the range of cells.
I have not having any luck with the following formula for an array range S12 through HM14 :
=(COUNTIF(S12:HM14,(LEFT(S12:HM14,4) = 9103)))
I've had success with COUNTIF with single values, but the "complex" value causes the COUNTIF to fail.
Zero is the result returned.
Thanks.
J
Bookmarks