Syntax for UNIQUE Function reference multiple Table column headers

Hi All,

I appologise if this has been covered anywhere. I couldn't find anything relating to this very basic question.

I want to extract unique values from a table. No Problem - Unique(TableName[Column1], false) does the trick. This only gives me the results from one column.

However, if is use Unique(array,false) I can get unique values from several columns in the resultant array.

I have tried various combinations of Unique (TableName[Column1][Column2],false) and Unique (TableName[Column1,Column2],false) etc, but I am missing something.


Does anybody know the syntax that will allow me to use the Unique Function on a Table with multiple columns?

Thanks in advance.

Jeff

There are instructions at the top of the page explaining how to attach your sample workbook.

Thanks for sharing.