LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Counting incidences of surname and date of birth and rearranging s

Hope somone can help, this should be easy but I'm new to excel.
I have a sheet of 1000+ names with columns of surname, initial, date of
birth. I need to count the incidence of unique records and then rearrange the
sheet with the name with the most occurrences at the top, and following names
in decreasing incidence. Any ideas gratefully acceted
--
painless2
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Birth date from age JP6262AMY Excel Worksheet Functions 2 March 10th 08 06:30 PM
Rearranging a date Janice B. - Cleveland, Ohio Excel Worksheet Functions 3 March 14th 07 06:43 PM
How do I convert a date of birth to an age? Michael Excel Worksheet Functions 1 February 5th 07 12:11 AM
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM
ages/date of birth irishchick28 Excel Worksheet Functions 1 March 21st 05 09:22 PM


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"