Original:
E&O | [NULL] | [NULL] |
NAME1 | 1 | 11 |
E&O | [NULL] | [NULL] |
NAME1 | 2 | 22 |
NAME2 | 3 | 33 |
P&C | [NULL] | [NULL] |
NAME1 | 4 | 44 |
E&O | [NULL] | [NULL] |
NAME1 | 5 | 55 |
NAME2 | 6 | 66 |
Desired result:
E&O | [NULL] | [NULL] |
NAME1 | 1 | 11 |
E&O | [NULL] | [NULL] |
NAME1 | 2 | 22 |
NAME2 | 3 | 33 |
E&O | [NULL] | [NULL] |
NAME1 | 5 | 55 |
NAME2 | 6 | 66 |
hi everyone, is there a way to filter my table so that every time it sees "E&O" it will filter for that row plus all the values below it. If it sees another heading like "P&C" in the example (headings are distinguished by the null values in the other two columns), it will ignore it? Thanks in advance!
Solved! Go to Solution.
You can Multi-row formula to group and filter it out. Refer below
Workflow:
Hope this helps : )
Thanks for the great solution, what if lets say there are hundreds of other codes that aren't "E&O". Is there a way to adjust what you have to account for that instead of hard coding each code that isn't "E&O"?