|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2005, 04:10 PM
|
|||
|
|||
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 
|
|
#2
May 12th, 2005, 04:26 PM
|
|||
|
|||
|
=SMALL($B$3:$B$10,1)
=SMALL($B$3:$B$10,2) =SMALL($B$3:$B$10,3) -- HTH Bob Phillips "Pete" wrote in message ... 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
|
|
#3
May 12th, 2005, 04:31 PM
|
|||
|
|||
|
Smallest 3 numbers if you have unique (no repeats)
= small(b3:b10,1) = small(b3:b10,2) = small(b3:b10,3) However if you have numbers repeat then Smallest = min(b3:b10) 2nd smallest =min(if(b3:b10small(b3:b10,2),b3:b10)) array entered (ctrl+shift+enter) 3rd smallest =min(if(b3:b10small(b3:b10,2),b3:b10)) array entered (ctrl+shift+enter) "Pete" wrote in message ... 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 | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting alphanumeric numbers | maurice.centner | General Discussion | 2 | May 6th, 2005 02:00 AM |
| Match Last Occurrence of two numbers and Count to Previous Occurence | Sam via OfficeKB.com | Worksheet Functions | 33 | April 4th, 2005 02:17 PM |
| Searcing multiple numbers | Ken | General Discussion | 4 | November 6th, 2004 02:53 PM |
Linear Mode
