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
Bookmarks