Selva,
Why not have a go & customize a pivot solution to suit exactly what the OP
posted that she wanted here? Post a link to your sample which specifically
meets the OP's specs here. I'm sure that if your option is easier it would
be even better & deeper appreciated by the OP, whose post was challenging to
the extent that it remained responseless for more than 8 hours.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Socko" wrote in message
...
You may alternatively use an easier way to analyze things with pivot,
and if once you get comfortable with pivot , you may find that pivot
helps with various data analysis...
Have a look at the attached excel file demonstrating pivot with a data
similar to your example
http://www.sockofiles.350.com/gdescanalysis.xls
You may be interested in various links to web pages with intermediate
to advanced pivot table resources at following link
http://socko.wordpress.com/?s=pivot
I hope this helps.
Selva V Pasupathy
For more on Excel, VBA, & other resources
Please visit http://socko.wordpress.com/