Single column generated dynamic list (not drop-down list) based on unique only numbers across multiple columns

[campos1578]

Hey Team,

I am generating dynamic lists across 4 columns and want the 5th column to show only unique numbers out of the 4 lists (Example A). However, the cells within the 4 columns are running a formula. (=FILTER(ItemDetails[CATALOG_ITEM_ID], (ItemDetails[[ Weight]]<=$Q$16) * (ItemDetails[[ Width]]<=$R$16)*(ItemDetails[[ Depth]]<=$S$16*(ItemDetails[[ Height]]<=$T$16))))

I need columns AH:AK to remain dynamic AND column AL to dynamically list only unique values from AH:AK.
ExampleA:

Can someone help me with this using a formula?

Thanks,
Jonathan

 

[Fluff]

How about

=UNIQUE(TOCOL(AH3#:AK3#,1))

change the 3 to match where the filter formula is