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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…