value category
0.48 1
0.64 1
0.70 1
0.74 1
0.76 1
0.45 2
.....

I want to return the MIX or MAX of value for category 1, then category
2, etc. The output must be displayed in a seperate work worksheet like
this:

category min max
1 XX XX
2 XX XX

XX represents what I am trying to solve for. Any help? All replies are
greatly appreciated. thx!


--
Thrain
------------------------------------------------------------------------
Thrain's Profile: http://www.excelforum.com/member.php...o&userid=29192
View this thread: http://www.excelforum.com/showthread...hreadid=489274