smallest numbers

  • Thread starter Thread starter tarius
  • Start date Start date
T

tarius

what formula would i use to pick the three lowest numbers from a grou
of numbers in a row and put them in other cells.


1040 849 0 1051 795 1038 1037


put them here

0 795 84
 
Tarius, if the numbers are in different cells A1:G1 in this case use the
small function something like this
=SMALL(A1:G1,1) =SMALL(A1:G1,2) =SMALL(A1:G1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
You can also do it an array formula as follows...

assuming your data is in the range a1:g1..

select the number of cells you need.. (for the smallest two select
cells, for 3 smallest 3 cells. etc.)

=small(a1:g1,{1,2,3}) in any one of the the selected cells and then us
ctrl shift and enter instead of just enter..
 
If the sample is in A2:G2...

In A4 enter & copy across to C4:

=SMALL($A$2:$G$2,COLUMN()-COLUMN($A$4)+1)
 
Back
Top