Help with excel filter formula

[manekankit]

Dear members, having below query with excel filter function.

Given below is data set, formula 1 and formula 2.

Having query with formula 2 given below.

I am not getting why result of formula 2 is including item with units sold =4 when my condition for filter is unit sold is >5. (formula 2 is also not including units sold =7 item).

I am using office 365 desktop version.

Thanks.

A 1 Employee B Units Sold C Average Price 2 Tom 4​ 2.99​ 3 Jack 3​ 2.95​ 4 Suzie 7​ 2.75​ 5 Rajesh 4​ 2.64​ 6 Kevin 4​ 3.05​ 7 Belinda 3​ 2.52​ 8 Sally 8​ 3.18​ 9 David 9​ 2.52​	This is a data set range (a1 to c9)
Result of formula 1 Suzie 7​ 2.75​ Sally 8​ 3.18​ David 9​ 2.52​	Formula 1 =FILTER(SORTBY(A2:C9,B2:B9,1),SORTBY(B2:B9,B2:B9,1)>5)	This formula is giving correct result providing list where unit sold quantity is >5
Result of formula 2 Tom 4​ 2.99​ Sally 8​ 3.18​ David 9​ 2.52​	Formula 2 =FILTER(SORTBY(A2:C9,B2:B9,1),B2:B9>5)	The query is why this formula is including "Tom" when it has unit sold = 5 but filter condition is >5

 

[Fluff]

Glad we could help & thanks for the feedback.