Find the n smallest numbers

This shows you how to find the three smallest values in a range.
This must be entered into 3 cells
={SMALL(B2:D5, {1,2,3})}


Related Formulas

Find the n largest numbers


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top