Hi griff,

Another spin on John C's answer:

=MIN(IF(M230,M23,MAX(M23,J23,G23,D23)),IF(J230,J 23,MAX(M23,J23,G23,D23)),IF(G230,G23,MAX(M23,J23, G23,D23)),IF(D230,D23,MAX(M23,J23,G23,D23)))

This will result in a zero or negative number if all values are either zero
or negative, in which case you would want to add another condition for that
case.

Hope this helps.
Peggy

"griff" wrote:

good afternoon all

I have been sent a sheet which contains lots of Min formulae which look for
lowest of 4 separate cell values, eg =MIN(M23,J23,G23,D23)

The 'challenge' I have now is to get them to ignore any negative numbers.

Can anyone help? I have tried looking around, but so far the solutions I
have seen using MIN and SMALL all seem to need the data to be in contiguous
cells...

Thanks in advance for any helpful advice

cheers

Griff