MS Excel formulae

  Roland Butter 15:08 02 Oct 04
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 04

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now