Hi All,
Is there a formula i can use (cant use a pivot table for this) that looks in a column then gives me the highest number of unique items?
Ie:- Column A contain 2000 rows, within those rows there are 50 unique numbers. One of those numbers is repeated 350 times, then the other 49 a repeated less. I want to be able put a formula in that returns a value of 350.
Thanks in advance
Blunder
Is there a formula i can use (cant use a pivot table for this) that looks in a column then gives me the highest number of unique items?
Ie:- Column A contain 2000 rows, within those rows there are 50 unique numbers. One of those numbers is repeated 350 times, then the other 49 a repeated less. I want to be able put a formula in that returns a value of 350.
Thanks in advance
Blunder