MS Excel formulae

  Roland Butter 15:08 02 Oct 2004
Locked

i have a speadsheet with names in one of the columns. As some of the names appear several times (several rows) how can i reduce the appear of each person's name to only once - and ideally count how many individual names appear in the spreadsheet?

  cherria 15:14 02 Oct 2004

select the column of names, go to Data->Filter->Advanced Filter.

select Filter list in place and Unique records only

click ok

This will show you just one occurence of each name. You can now copy this to a new sheet if you want to create a list of unique names.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017