manekankit
Board Regular
- Joined
- Feb 1, 2019
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
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.
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.
| This is a data set range (a1 to c9) | |||||||||||||||||||||||||||||
Result of formula 1
| 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
| 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 |