Forum Discussion
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 another and return a True/False?
I manually added the two green tables to show what I'm after.
Thanks !!! I've uploaded the book here if you need
https://1drv.ms/x/s!AmLPbYDKpMwCgl4wJbdDq33sQk-Y?e=5PJG9u
1 Reply
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
