Using Sort, Unique & Filter to create a single list from a table..

[Spoursy]

Hi, Im using this formula to condense data from a table into a single column of data
=SORT(UNIQUE(FILTERXML("<a><b>"&SUBSTITUTE(TEXTJOIN("|",TRUE,'Unique Master List (filtered)'!CV17:DQ110),"|","</b><b>")&"</b></a>","//b")))

If i change the table range past row 110 i get a #Value! error

Any ideas welcome

 

[Fluff]

Glad to help & thanks for the feedback.