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
=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