Need Formula

T

tiang1209

I have 4 numbers, example A1=7, B1=6, C1=7, D1=7, the final result I
want is 6, 7 sort from smaller number in different cells without
repeating the same number. Please help.
 
V

vezerid

For the smallest number (say you enter it in A2):
=MIN(A1:D1)
For the next smaller (say you enter in B2):
=MIN($A$1:$D$1+IF($A$1:$D$1>A2,0,100000))

The second (B2) is an array formula, you must enter with the
combination Shift+Ctrl+Enter. You can then copy B2 formula as far to
the right as necessary.

The 100000 is a number guaranteed to be larger than any you will
encounter. After a point your cells will show 1000006, 1000007 etc,
which shows you are finished with the unique numbers.

HTH
Kostis Vezerides
 
T

tiang1209

tiang1209 said:
I have 4 numbers, example A1=7, B1=6, C1=7, D1=7, the final result I
want is 6, 7 sort from smaller number in different cells without
repeating the same number. Please help.
Click to expand...

Another example, if A1=2, B1=9, C1=7, D1=5,
the result sort from smaller number is 2, 5, 7, 9.
This one I have no problem.
Once I changed the one of the number of B1 or C1 or D1 to 2,
the result I need is 2, 5, 7 or 2, 5, 9 or 2, 7, 9.
Please help to get a formula to get the result I want.
 
V

vezerid

tiang

the formula I gave you will behave as you want for the examples that
you mention. Did you try it?

Kostis Vezerides
 
Top