Thank you RagDyR

RagDyeR wrote:
You did say "lowest" in your post, but the subject line said lowest *AND*
highest.

So, just change the MAX to MIN, and you'll have them both.
Try these *array* formulas:

=MAX(IF(A1:A7="ACC",B1:D7))

=MAX(IF(A1:A7="BCC",B1:D7))



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1