Forum Discussion
LachlanB98
May 16, 2024Copper Contributor
If identical values in one column return identical or different values in another column True/False
Hi all, I have duplicate cell values in column 1 (PLU). Can someone please provide me with a formula to determine when duplicate values in column 1 (PLU) return non-identical cell values in anoth...
Riny_van_Eekelen
May 16, 2024Platinum Contributor
LachlanB98 See attached. Added two formulas, one in each table.
=COUNTA(UNIQUE(FILTER(Table3[PORTION],Table3[PLU]=[@PLU])))=1
and
=COUNTA(UNIQUE(FILTER(Table3[LINKED PRODUCT],Table3[PLU]=[@PLU])))=1