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.