Sorting Queried Data in Descending Order

egold31

Hi Everyone,

I was wondering if there is a way to sort queried data in descending order. I'm aware there is no explicit SORT function and the way I set up my data sheet, I am unable to sort the rows/columns that way.

The formula I am using is as follows:

=JOIN(COLLECT({Domain}, {Status}, "DONE"), CHAR(10))

This is retrieving a list of domains where the status is DONE. Is there anyway in this formula to sort the domains in descending order as they are represented by numerical values?

Thank you for your help.

kowal

hi @egold31,

Why the built in column sorting is not working for you?

Paul Newcome

How many domains are there that you would need to sort in a single JOIN function?