ChillDrJill
New Member
- Joined
- Aug 23, 2020
- Messages
- 3
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
I have been successfully using this formula: =UNIQUE(FILTER(pp_tasks,(wbs_Hire=1))) with great success to apply an auto filter to a set of unique values. In a certain use case, this data set is still too large and I only want it to return the first 200 values. This formula: = INDEX( UNIQUE(pp_tasks), SEQUENCE(10) works to accomplish this goal, but I cannot identify the syntax to fold in the FILTER.
Am I trying to do too much with one formula and simply need to build yet another helper column?
Am I trying to do too much with one formula and simply need to build yet another helper column?