Discussion Starter · #1 ·
I have a column in a spread sheet with approximately 200 rows. I need to know how many of the items are unique. Short of sorting the column and then manually counting, is there any function or trick I can use to get the number of unique items in those 200 rows. For example, if I have 201, 202, 203, 203, 204, 204, 205, 206. I would want the result count to be 6 not 8. And no I can not delete the duplicate items as there is information in other columns that is different. Any ideas/solutions?