helpneeded2
Board Regular
- Joined
- Jun 25, 2021
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
I can seem to get UNIQUE, SORT and FILTER all working together.
Here's some example data:
This is a simplified example table, and an important note is that my actual table will contain various blank rows in between the rows with data.
I want to sort the table by Column B, and filter the table for data in Column A where the value must be <>"", and then apply Unique, as there there may be multiple entries of the same number in Column A.
How can this be achieved. Everything I try results in a SPILL error?
Here's some example data:
123 | John | Dogs |
444 | Mary | Cats |
56 | Sue | Birds |
This is a simplified example table, and an important note is that my actual table will contain various blank rows in between the rows with data.
I want to sort the table by Column B, and filter the table for data in Column A where the value must be <>"", and then apply Unique, as there there may be multiple entries of the same number in Column A.
How can this be achieved. Everything I try results in a SPILL error?