"Myrna Larson" wrote in message
...
It doesn't work for me.


It doesn't work for me either when I have a column of mixed names instead of
lazily copying "Bob" down the column!

Oops!

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
MIN((B1:B6="Bob")*(C1:C6)))