Hi Everbody,

I have problem in using the function small when I'm trying to get levels of the smallest numbers within a range I faced problems with repeated numbers,

for example:
here is the sequence:

2 2 2 2 3 3 5 10

when I used the function small: =small(l48:l55,2) it gave me the value 2 since I want the second smallest number which is 3 and the third is 5

Or if there is an Idea of putting this sequence in another but with a formula that can remove the repitition

So is there a formula that can help me in solving this problem ?

Thank you very much