Google sheets query to get unique client IDs and order by sales value

Question

I'm trying to get a list of unique client IDs and sorted in a desc order based on sales value in a different column. My data: Client ID Column A Sales Value Column B

Thank you for your help.

I managed to get a unique list of clients eliminating where Sales Value is blank, but this returns 2 columns unique client IDs and Sales Value, but I would like to get just a list of IDs and have the IDs sorted by the sales value desc order.

`=unique(filter(Revenue_data!A1:B1000,Revenue_data!B6:B1000<>""))`

Answer 1

You may try:

=unique(choosecols(sort(filter(Revenue_data!A2:B,Revenue_data!B2:B<>""),2,),1))