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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…