campos1578
New Member
- Joined
- Jan 3, 2020
- Messages
- 22
- Office Version
- 365
- Platform
- MacOS
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
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