COUNTIF Return 3.1 not 3.10
Posted on 2011-09-22
Here is my problem.
I am trying to make a spreadsheet that is going to be imported by another program. And I need to have the formula keep count of the number of times something has been selected above.
Here is what I am doing. I am using a VLOOKUP to find the Value Column. Then I am using a COUNTIF to Total # of time occurances in the column.
Then using CONCATENATE to Produce Value Displayed
Group Value Total # Correct Value Value Displayed
Plate-Carbon 3.1 1 1 3.1.1
Plate-Carbon 3.1 2 2 3.1.2
MISC. 3.10 3 1 3.10.1
The Issue I am having is that COUNTIF is counting 3.10 as 3.1
I can't change the the number to be decimial based because I need 3.1 and 3.10.