=MIN(IF(Sheet1!$B$2:$B$200=$A2,Sheet2!$A$2:$A$200) )

which is an array formula, so commit with Ctrl-Shift-Energy, and thenj

=MAX(IF(Sheet1!$B$2:$B$200=$A2,Sheet2!$A$2:$A$200) )

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Thrain" wrote in
message ...

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