ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 343
- Office Version
- 365
- Platform
- Windows
Would it be possible to exclude rows from a filtered list in which that said rows are included from the filtered criteria
i have a current formula that will filter >5 # of days (courtesy of sir @Fluff ). However, i have a separate report that i need to exclude 1 name (Welles) from the list.
i have a current formula that will filter >5 # of days (courtesy of sir @Fluff ). However, i have a separate report that i need to exclude 1 name (Welles) from the list.
testing.xlsx | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
1 | Name | no. | section | dept | qty | Current formula | expected result | |||||||||||||||
2 | Lara | 1 | ZA | Z | 5 | SORTBY | Name | no. | dept | # of days (updated everyday) | Name | no. | dept | # of days (updated everyday) | ||||||||
3 | Gayle | 2 | AB | A | 10 | Z | Gayle | 2 | A | 10 | Gayle | 2 | A | 10 | ||||||||
4 | Ponting | 3 | CD | C | A | Kipling | 7 | X | 6 | Kipling | 7 | X | 6 | |||||||||
5 | Welles | 4 | DE | D | 20 | X | Connery | 10 | B | 32 | Connery | 10 | B | 32 | ||||||||
6 | Perot | 5 | BC | B | 5 | B | Welles | 4 | D | 20 | Porter | 9 | D | 12 | ||||||||
7 | Murdoch | 6 | EF | E | 4 | C | Porter | 9 | D | 12 | ||||||||||||
8 | Kipling | 7 | XY | X | 6 | D | ||||||||||||||||
9 | Coolidge | 8 | TU | T | T | |||||||||||||||||
10 | Porter | 9 | DE | D | 12 | E | ||||||||||||||||
11 | Connery | 10 | BC | B | 32 | |||||||||||||||||
Sheet11 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I3:L7 | I3 | =LET(f,FILTER(CHOOSECOLS(A2:E100,1,2,4,5),E2:E100>5),SORTBY(f,MATCH(INDEX(f,,3),G3:G10,0))) |
Dynamic array formulas. |