Mattdim805
New Member
- Joined
- Dec 11, 2013
- Messages
- 11
I have a table in Google Sheets that is automatically populated by referencing a data set using UNIQUE and FILTER formulas. I'm trying to add a SORT formula to it so that I can populate the last column from Z to A.
Below is the current code, which sorts the table from A to Z by the Openers column:
When I try to sort the table by ratio column, it moves the formula that's generating the list of people, which causes a bunch of white spaces to show up on top. This causes half of the table to not accurately report. See the example below.
I know I can do it using the below code in a different cell, but I'm trying to declutter the sheet if at all possible, so I want to avoid having to created duplicated tables for sorting.
Any guidance on how I can sort the Ratio table from Z to A would be greatly appreciated - thanks!
Below is the current code, which sorts the table from A to Z by the Openers column:
Code:
=SORT(UNIQUE(FILTER('2021 Lead Data'!D:D,('2021 Lead Data'!B:B=2)*('2021 Lead Data'!D:D<>""))))
When I try to sort the table by ratio column, it moves the formula that's generating the list of people, which causes a bunch of white spaces to show up on top. This causes half of the table to not accurately report. See the example below.
I know I can do it using the below code in a different cell, but I'm trying to declutter the sheet if at all possible, so I want to avoid having to created duplicated tables for sorting.
Code:
=SORT(G4:J23,4,FALSE)
Any guidance on how I can sort the Ratio table from Z to A would be greatly appreciated - thanks!