| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for the smallest number that isn't less than zero
Hello all! I have a formual set up to return the smallest number in a
column... =SMALL($E$4:$E$104,1) However, I need to to return the smallest number greater than zero. We have a contest going on and based on sales vs. the employee guess we may have some negative numbers come up so I don't want them to show in my top 5... Can you help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
