How do I lookup a 'quantity' of items in excel?
- by KronoS
Let's say I have a quatity of items:
1 2 3 4 5 4 3 2 1 2 3 4
in a column of cells. What I want to be able to do is count the quantity how many unique "items" there are in this array:
1 -- 2
2 -- 3
3 -- 3
4 .. 3
And so forth. I want the table to look like this:
Also, is there a way to accomplish this if I don't know all of the values of the array to begin with? I'm looking for a way to have excel search an array, find a unique value, count how many times that value is in the array, and then move onto the next values.
