How do I count or display unique data in a column?
I want to display all the unique names in a column, but I can't find a
"unique" command. I also want to be able to count all the unique names in the column. Ideas? |
A couple of ways, the easiest would be to use advanced filter,
datafilteradvanced filter, select unique records only and preferably copy to another location, then use a simple counta =COUNTA(Range) (deduct 1 for the header) if you filter in place use subtotal =SUBTOTAL(3,Range) or you could use an array formula, cannot be entered in the first row since it uses the same column and the row above where it's first entered =INDEX(Range,MATCH(0,COUNTIF($I$1:I1,Range),0)) is how it would look if it is entered in cell I2, enter it with ctrl + shift & enter and copy down until you get an error -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "kbeilers" wrote in message ... I want to display all the unique names in a column, but I can't find a "unique" command. I also want to be able to count all the unique names in the column. Ideas? |
All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com