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.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!)
David Miller (dlmille)
This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…