| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting to ignore zeros
That's got it exactly. Although the zeros are displayed, they're ignored.
Thank you -- Traa Dy Liooar Jock "Peo Sjoblom" wrote: Assuming that you don't have any negative values =$D4=SMALL($D$4:$D$15,COUNTIF($D$4:$D$15,0)+1) -- Regards, Peo Sjoblom "Jock" wrote in message ... Hi, How do I get this: =COUNTIF($D4,(MIN($D$4:$D$15))) to ignore zero's? -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formats to ignore blank cells | Excel Worksheet Functions | |||
| Conditional Formats to ignore blank cells | Excel Worksheet Functions | |||
| Median calculation and ignore zeros | Excel Discussion (Misc queries) | |||
| Formula/formatting to omit trailing zeros | Excel Worksheet Functions | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
