Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Earlier I posted a question about ignoring zero values, Well when I posted
that it helped, I had not fully tried the suggestion with zeros and zero values. Well here is what I have in the cell that is giving me the problem. =MIN(D162:D181,D136:D155,D110:D129,D84:D103,D58:D7 7,D32:D51,D6:D25) many of these cells contain a 0 (Zero) value from another formula so I cannot just leave them blank. I tried =MIN(If(D162:D181,D136:D155,D110:D129,D84:D103,D58 :D77,D32:D51,D6:D250,D162:D181,D136:D155,D110:D12 9,D84:D103,D58:D77,D32:D51,D6:D25)) But that doesn't work either, any suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Summary Page Question | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |