Hi
e.g. the array formula
=MIN(IF(A1:A100="value",B1:B100))

--
Regards
Frank Kabel
Frankfurt, Germany

Donkey wrote:
How do I return the smallest value from one range based on another
condition from another range eg