I colums a I have values from 1 to 20 repeating seveal times. In column
B I have many different values. I need a formula that with for example
search for the maximum value in column B while column A = 7. Any
Ideas? Thanks.

Karl


--
kwrohde
------------------------------------------------------------------------
kwrohde's Profile: http://www.excelforum.com/member.php...fo&userid=5721
View this thread: http://www.excelforum.com/showthread...hreadid=549456