On Nov 30, 4:17*pm, Herbert Seidenberg
wrote:
Excel 2007 Pivot Table
No formulas of any kind needed.http://www.mediafire.com/file/d2m2nz...11_30_09a.xlsx

Hi Herbert,

Thanks for the pivot table idea...but unfortunately the pivot table
lumps all the same values together. What I am after is same values but
"local" to be lumped together and then find the min and max.

Thanks again for your help!