Hello
I have this table:
I want to filter the table based on row 2 being non zero, then sort the array by row 3 (max to min) and then for each A, B, C, D, create the text "C has 3, A has 1" which is basically combining the values of row 1 and 2 into some text and consolidating them together after they have been sorted based on row 3.
Any idea?
Thanks!
I have this table:
A | B | C | D |
1 | 3 | ||
4 | 5 | 7 | 3 |
I want to filter the table based on row 2 being non zero, then sort the array by row 3 (max to min) and then for each A, B, C, D, create the text "C has 3, A has 1" which is basically combining the values of row 1 and 2 into some text and consolidating them together after they have been sorted based on row 3.
Any idea?
Thanks!