Counting incidences of surname and date of birth and rearranging s

's Computer Specifications

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

's Computer Specifications

Hi,

You probably need a 'Helper Column'.

Assuming you names are in column A1:A1000 put this in row 1 of an empty
column and drag down

= COUNTIF($A$1:$A$1000,A1)

Select all you columns including the 'Helper' and sort Descending and the
most common names will be at the top. You can also hide the helper column.

Mike

"Painless2" wrote:

> 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

's Computer Specifications

Thanks Mike, I'll give it ago.
--
painless2

"Mike H" wrote:

> Hi,
>
> You probably need a 'Helper Column'.
>
> Assuming you names are in column A1:A1000 put this in row 1 of an empty
> column and drag down
>
> = COUNTIF($A$1:$A$1000,A1)
>
> Select all you columns including the 'Helper' and sort Descending and the
> most common names will be at the top. You can also hide the helper column.
>
> Mike
>
> "Painless2" wrote:
>
> > 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

's Computer Specifications

Painless it seems really painless!!
i suppose your columns are
surname | initial | dateofbirth |
insert a column and name it as occurance

surname | initial | dateofbirth | occurance

put the formula in occurance column second row = COUNTIF(A2:A2000,A2)
here A2 to A2000 is supposed to be the column with names

fill down the formula.
select the entire range and sort with occurance colum desending order!

is this what you need??

"Painless2" <(E-Mail Removed)> wrote in message
news:662E1DBC-A6AD-49AD-9A8D-(E-Mail Removed)...
> 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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to write; specific date minus date of birth equals years	=?Utf-8?B?anVzdCBhbm90aGVyIE1pa2U=?=	Microsoft Access Queries	7	18th Mar 2006 03:56 AM
Duplicate forms-prevention on use of date of birth+ surname	=?Utf-8?B?cHJhdl8xMjM=?=	Microsoft Access Getting Started	1	25th Feb 2006 11:54 PM
Acces 2003: Substraction between date of birth and system date	=?Utf-8?B?Sm9oYW4=?=	Microsoft Access Forms	4	17th Feb 2006 01:27 PM
formula to calculate age using birth date and current date	=?Utf-8?B?bGFsYWg=?=	Microsoft Excel Worksheet Functions	2	20th Nov 2005 10:51 PM
Counting the incidences in a row	=?Utf-8?B?TWFyeWFubiBI?=	Microsoft Access Getting Started	2	25th Sep 2005 03:04 AM