Forum Discussion
Formula for for writing common numbers
What formula will help me write common numbers from 2 cells? In cell A1 I have: 1,2,3. In cell B1 I have: 2,3,4. I would like cell C1 to write to me: 2 and 3.
Thanks
Grosso1280 alternatively this formula should work (but it does return a blank because I reference the entire column instead of only the data set range):
=IFERROR(SORT(INDEX(B:B,UNIQUE(MATCH(A:A,B:B,0)))),"")