Related Posts
Anyone working in appdynamics??
Happy new year everyone👍🏼
Additional Posts in Excel Genius
Anyone know what these badges are?

Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.







Not sure what your ultimate goal is here. But if you are looking to create a list of all unique parts then you could just use the unique function. Eg
=unique(A:A)
Would make a list that is 1,1,1,2,1,1,2 (in a column) into
1,2 (in a column)
Then, you can use a countif function to tell you how many times they appear in your list
If the original data is in column A and the unique list is in column B, in column C you’d do a countif function where the range is all of the data in column A (make sure to lock the cells), and the criteria is the single cell to the left in column B. Then drag that formula down and it should get the count of each unique item in the list
Use a Microsoft list, just add a record each time you have a new part. Use Power Query and excel to manipulate the list data and show you the necessary totals.