I have a lot of numbers in a column and I want Excel to return the 4th
smallest number so I'm using the formula small(range,4). However, the small
function works in this way: if I have the numbers (1,1,2,2,3,4) the function
small(range,4) returns 2, but I want it to return 4 since that is the 4th
smallest number.

Any advice on how to tweak the small function to get it to work in this way,
or an alternative function that I can use?

Thank you!