IF statement taking ties in Rank

[JTL9161]

I am using this formula =IFERROR(RANK(AZ2, AZ$2:AZ$21,1),"") to rank numbers in 20 rows (1 column) from low to high 1 through 20.
From that column I use this formula =IF(BA2<9, AZ2,"") to find the lowest 8 numbers

BUT that formula takes both numbers if there is a tie. Meaning if 2 numbers or more in the rank from 1 to 20 column has 2 of the same number then it takes more than 8 of the lowest. If one of the rank numbers are duplicates, then i get the 9 of the lowest numbers not 8.

Is there a way to correct this so regardless of ties in the rank the if formula column?

Thanks in advance,
James

 

[Fluff]

How about

=TAKE(SORT(AZ2:AZ21),8)

 

[JTL9161]

Perfect. Thanks

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Burrgogi]

How about

=TAKE(SORT(AZ2:AZ21),8)

I actually have the same problem but I can't use your formula here because I'm using an old version of Excel. Is there an alternative solution?

 

[Peter_SSs]

I actually have the same problem but I can't use your formula here because I'm using an old version of Excel. Is there an alternative solution?

Like this?

25 03 23.xlsm
	AZ	BA
1
2	9	1
3	13	3
4	7	3
5	6	3
6	18	4
7	7	6
8	18	7
9	7	7
10	3
11	13
12	9
13	1
14	4
15	8
16	9
17	8
18	3
19	7
20	8
21	3
Lowest 8

Cell Formulas
Range	Formula
BA2:BA9	BA2	=SMALL(AZ$2:AZ$21,ROWS(BA$2:BA2))