Grouping ranges
 

I have an Excel spreadsheet that contains the following info:
SampleID,%Metal,Composition,Volume
What I need to do is first provide a count of Samples with the same %Metal
then within those groups I want to show the counts that fall into certain
Volume ranges.
For example: I have 67 Samples that have 20%Metal, 30/67 fall into Volume
range 1-100, 21 fall into Volume Range 101-500, 16 fall into the Volume range
500.
I think a Pivot table can give me the %Pt count but I don't know how to
group the Volume into a range. Any help is greatly appreciated.

J,

Perhaps this post on setting up a frequency distribution can help:

http://www.pdbook.com/index.php/exce...bins_formulas/

--
Regards,
John Mansfield
http://www.pdbook.com


"J" wrote:

I have an Excel spreadsheet that contains the following info:
SampleID,%Metal,Composition,Volume
What I need to do is first provide a count of Samples with the same %Metal
then within those groups I want to show the counts that fall into certain
Volume ranges.
For example: I have 67 Samples that have 20%Metal, 30/67 fall into Volume
range 1-100, 21 fall into Volume Range 101-500, 16 fall into the Volume range
500.
I think a Pivot table can give me the %Pt count but I don't know how to
group the Volume into a range. Any help is greatly appreciated.