Forum Discussion
Common Values in 3 Columns
Dear Experts, I have a data like below, in Col-A/B/C and in Col-E , I want the common rnti's from A&B&C Col, Thanks in Advance, Br, Anupam
Try the following formula-
=LET(x,UNIQUE(TOCOL(A2:C19,1)),y,XMATCH(x,A2:A19)+XMATCH(x,B2:B19)+XMATCH(x,C2:C19),FILTER(x,ISNUMBER(y)))