Multiple minimum numbers

Copper Contributor

How can I look up the two small numbers in a range and post them in adjacent cells?

For example, here are two ranges with whole numbers:

Range A Range B

3             4
2            4
1            3
1           2

Expected Outcome:

1          2
1          3

 

1 Reply