| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Min function over 4 separate cells, but ignoring negatives
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring #N/A in a DSUM function | Excel Discussion (Misc queries) | |||
| How do I use Excel with times which are negatives? | Excel Discussion (Misc queries) | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
| Sort ignoring negatives and positives | Excel Worksheet Functions | |||
| Formula to average ignoring negatives? | Excel Discussion (Misc queries) | |||
Threaded Mode
