| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculate Minimum numbers
I have a need to calculate the 3 smallest numbers in a set of 7. I have tried
the min function but this only gives me one number. The nubers are listed in (B3:B10) my formula is in (B12). Some cells can be blank and some or a negitive, while a third senerio would be that you could have repeatitive #'s (I.e -13,_,_,2,_,-2,-13). Any thoughts -- Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate In-Between Numbers | Excel Worksheet Functions | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
Threaded Mode
