Re: ranking names
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Dec 2006 09:56:43 -0400
1) Use Chip's method to extract the unique names: see
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique
2) Copy and Paste Special ->Values these names to a new column
3) Use COUNTIF to find how many times each name in the unique column occurs
in the original data.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dave" <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:56873514-429A-46B7-8074-155F37EADE03@xxxxxxxxxxxxxxxx
I have a list a1.a1000 first names, b1.b1000 last names, that are sometimes
duplicative, sometimes not:
A B
Joe Smith
Joe Smith
Joe Jones
Frank Jones
Sally Doe
I want to sort these in rank order with a second column (D) that shows how
many times they show up:
C D
Joe Smith 2
Joe Jones 1
Frank Jones 1
etc.
Thank you
Dave
.
- Prev by Date: Re: Finding cells that contain an apostrophe
- Next by Date: Re: How do we add a separator in Excel 2007 menu using VBA
- Previous by thread: Re: Finding cells that contain an apostrophe
- Next by thread: Re: ranking names
- Index(es):
