Counting ranges, please help

[SMutchnick]

Hey everyone, I haven't been able to figure out how to pull this off:
I've got a database of about 3,000 patients from which I will soon need to extract data for research.
Right now I am focusing on three of my columns, ***, AGE and RACE.
Using a pivot table I can see how many M's or F's are AA or Cau, and totals of both ***'s and all race's and so on.
But I cannot figure out how to, either by using a worksheet formula(s) or pivot table, display the distribution of patients through a set age-range.
My goal is to have a table that will show how many AA's, Cau's, etc and how many M's and F's of each race are between the ages of 10-20, 21-30. 31-40 and so on.

I have not been succesfull with any counting formulas, and in the pivot tables have not found a way to control how the AGE column is displayed, so as it is I have on row for virtually every age between 10 and 90. Not ideal.

Any help would be GREATLY appreciated, thank you!

-Sean

[pdberger]

SMutchnick --

On your pivot table, right-click on the header that has the age ranges.
Then, there's an option to 'group' them. Group them by every 10 years, and
you should be fine.

HTH

"SMutchnick" wrote:

>
> Hey everyone, I haven't been able to figure out how to pull this off:
> I've got a database of about 3,000 patients from which I will soon need
> to extract data for research.
> Right now I am focusing on three of my columns, ***, AGE and RACE.
> Using a pivot table I can see how many M's or F's are AA or Cau, and
> totals of both ***'s and all race's and so on.
> But I cannot figure out how to, either by using a worksheet formula(s)
> or pivot table, display the distribution of patients through a set
> age-range.
> My goal is to have a table that will show how many AA's, Cau's, etc and
> how many M's and F's of each race are between the ages of 10-20, 21-30.
> 31-40 and so on.
>
> I have not been succesfull with any counting formulas, and in the pivot
> tables have not found a way to control how the AGE column is displayed,
> so as it is I have on row for virtually every age between 10 and 90.
> Not ideal.
>
> Any help would be GREATLY appreciated, thank you!
>
> -Sean
>
>
> --
> SMutchnick
> ------------------------------------------------------------------------
> SMutchnick's Profile: http://www.excelforum.com/member.php...o&userid=35019
> View this thread: http://www.excelforum.com/showthread...hreadid=547552
>
>

[SMutchnick]

When I try your suggestion I get: "Cannot group that selection."

[SMutchnick]

Disregard that last reply, I see what you mean.

Thank you!