Hi:
One of the columns contains a number of values including the text string "1/2A". I am using the LEFT function to return only the "1/2" part of the string. E.g:
=LEFT(A10, 3)
I am using the LEFT function because all the values in the column have a letter after the "1/2" and a nested IF or Count IF statement is very inelegant. I would like my function to scan a column range and return a count value using the LEFT function to seperate the "1/2" from the full string (be it "1/2A" or "1/2B" etc. Any ideas?
One of the columns contains a number of values including the text string "1/2A". I am using the LEFT function to return only the "1/2" part of the string. E.g:
=LEFT(A10, 3)
I am using the LEFT function because all the values in the column have a letter after the "1/2" and a nested IF or Count IF statement is very inelegant. I would like my function to scan a column range and return a count value using the LEFT function to seperate the "1/2" from the full string (be it "1/2A" or "1/2B" etc. Any ideas?