ive got about 1500 data points. they are all ages.

how can i group the ages together, or at least tell me how many of each age there is?

ive got 3 90 year olds, 1 87y/o, 2 85 y/o

ages range from 17-90.

what kinda formula to put it?

7/16/2008 11:45:26 AM

Please Excuse My Dear Aunt Sally

7/16/2008 11:45:59 AM

i would make a cell for each agegroup and use COUNTIF.

7/16/2008 11:48:26 AM

pivot table FTW

7/16/2008 11:48:35 AM

why not sort by age and then you can look at it an see how many of each there are

7/16/2008 11:48:52 AM

^^

[Edited on July 16, 2008 at 11:49 AM. Reason : ^]

7/16/2008 11:48:59 AM

Quote :

"why not sort by age and then you can look at it an see how many of each there are"

or you can do this

7/16/2008 11:51:21 AM

explain this pivot table

or i can google it

7/16/2008 11:51:42 AM

^^well i have done that, 1500 entries isnt the best. dont wanna spend time looking through ages.

but i guess if all else fails i will

7/16/2008 11:52:30 AM

insert, pivot table, select the data, sort, PROFIT.

7/16/2008 11:54:59 AM

i taught her everything she knows btw lol

7/16/2008 11:57:37 AM

do a sort then subtotal and it'll prompt you to do sum or count then it'll automatically give you a count of how many people are in that age.

7/16/2008 11:59:51 AM

http://www.homeandlearn.co.uk/Me/mes9p5.html

pivot table instructions

7/16/2008 12:06:13 PM