24 янв. 2022 г. · I want to sort the table by Column B, and filter the table for data in Column A where the value must be <>"", and then apply Unique.

29 февр. 2024 г. · I want to sort this, but by column B, not by column A. Is this possible when using a UNIQUE array? I couldn't do it with the built in Sort functionality.

7 сент. 2024 г. · Hi, I am trying to create a dynamic drop down. I am working on the second unique list and I am referencing a column in a table.

24 сент. 2023 г. · This will look for the helper column number (1,2,3,4, etc.) using offset, lookup that column and return the value in Column A where it finds the Unique ID in ...

31 окт. 2023 г. · I have two columns of values...I want to tell Excel to sort col B (ascending), using values in col A, but I don't want col A to be sorted ...

25 авг. 2022 г. · How to SORT (and AVERAGE) the FILTER output of one column based on data from another column? Thread starter Rnkhch; Start date Aug 25, 2022.

28 авг. 2021 г. · New Member Column H is a data we want to track, maintain, and allow future changes. However, it needs to match the "unique position" line in ...

13 июн. 2022 г. · I am starting using the new array functions such as Unique, Filter, etc. I would like to get the unique list of two columns from two different sheets.

29 янв. 2021 г. · I have seven different columns with data that I want the =UNIQUE formula to draw from. So far no combination of formulas or other ...

18 июн. 2019 г. · I have a list of names on E10:E1000 and I am creating a list of unique values on this list using the function below.