nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 220
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I have a table called "Table" and I would like to filter results based on the value entered in cell F6. My criteria is; if there is exact match based on the value entered it will bring the results if not, the results will be shown as partially. My formula works but what I notice is; for exact match the same results are repeated based on the partial match for that result. how can i fix this in my formula? Thanks for your help!
=IF(NOT(ISERROR(FILTER(FILTER(Table;Table[LVL4]=$F6);{0\0\1\0\1\0\1\1\1\1})));FILTER(FILTER(Table;Table[LVL4]=$F6);{0\0\1\0\1\0\1\1\1\1});FILTER(FILTER(Table;ISNUMBER(SEARCH($F6;Table[LVL4])));{0\0\1\0\1\0\1\1\1\1}))
I have a table called "Table" and I would like to filter results based on the value entered in cell F6. My criteria is; if there is exact match based on the value entered it will bring the results if not, the results will be shown as partially. My formula works but what I notice is; for exact match the same results are repeated based on the partial match for that result. how can i fix this in my formula? Thanks for your help!
=IF(NOT(ISERROR(FILTER(FILTER(Table;Table[LVL4]=$F6);{0\0\1\0\1\0\1\1\1\1})));FILTER(FILTER(Table;Table[LVL4]=$F6);{0\0\1\0\1\0\1\1\1\1});FILTER(FILTER(Table;ISNUMBER(SEARCH($F6;Table[LVL4])));{0\0\1\0\1\0\1\1\1\1}))