Thank you for the information. I end up with the attached results:
Which are great. If I understand the formula right we are comparing
everything in the named ranges type and age with the corresponding row
and column labels we created in the second table shown above in red.
This is more of what I was looking for because now I can group by the
other categories and create histograms for them.
Is there a way to automatically adjust the ranges as additional data is
added or do I have to continuously update the ranges?
Steve
+-------------------------------------------------------------------+
|Filename: results.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=5203 |
+-------------------------------------------------------------------+
--
steve65
------------------------------------------------------------------------
steve65's Profile:
http://www.excelforum.com/member.php...o&userid=37510
View this thread:
http://www.excelforum.com/showthread...hreadid=571618