Forum Discussion

selecting_low_nmbers175's avatar
selecting_low_nmbers175
Copper Contributor
Jul 28, 2019

Multiple minimum numbers

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

 

Resources