6 февр. 2021 г. · I am using the unique() function to pull in a list of names and I want to sort the names based on another column. I can't specify the column ...

27 июн. 2024 г. · I have a table featuring non-unique numbers in COL A that I'm making a unique list from. In COL L, I have values that I would like to sort the UNIQUE list by.

22 нояб. 2023 г. · I have a listing of part numbers with varies duplicates and varying quantities on one sheet, and in another sheet created a list in Column B of the unique part ...

5 янв. 2024 г. · I'd like to order table B to show the categories in the order of “highest to lowest value” based on the “Amounts” column so that I can see which expense ...

17 окт. 2022 г. · Get UNIQUE values & fill another column based on the unique_array with TRANSPOSE + FILTER - with only one formula, not dragging it down for each value.

14 сент. 2022 г. · I am currently using the function =UNIQUE(FILTER(sheet1!C:C,sheet1!A:A=sheet2!B768)) to find all the unique values of one variable on a specific date.

31 мая 2023 г. · If I change the first column to =SORT(UNIQUE('Sheet2'!P2:P739)) then the list is sorted alphabetically, but I'd like to sort the list by the ...

5 мая 2024 г. · I'm looking to basically scan a particular column, let's say column "A" to find all distinct values and put them into another list.

4 окт. 2023 г. · I then want to sort all the unique names in those columns, using the UNIQUE (=UNIQUE(Form1!H2:H41)) formula, but it does just work one column.

9 июл. 2024 г. · Alternatively: Use a QUERY formula instead. This would populate the entire table in one go, and you can use the order by argument to sort it.