Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum from various columns without zeroes
Hi! Just a question:
I was computing for the minimum, using =min(f16,k16,p16,z16) but the problem is I don't want the minimum to equal to zero (I want to see the lowest positive number from these columns instead of zero). Is there a way not to include zeroes from these columns in looking for the minimum? Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Help with grouping columns | New Users to Excel | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |