sort unique values

[Chris1976]

Hi There

I have a formula I use to sort unique values located in a table. The values spill below the table in a cell I have selected

=SORT(UNIQUE(Table_Central_PL[Area Manager]))

I was wondering if you could sort unique values from one table in a second table and when spilling it does not include duplicates. I tried this by creating a second table but the but i only get a #spill error

[Bo_Ry]

Spill array can't use with Table
https://support.microsoft.com/en-us/...4-c4d4bc513d4b

try =IFERROR(INDEX(SORT(UNIQUE(Sample[District])),ROWS(E$27:E27)),"")

or put this in G28 =SORT(UNIQUE(Table_Central_PL[Area Manager]))