If I used =INDEX($C$7:$C$12,MATCH(B2,$B$7:$B$12,0)) it only returns the first exact value but I need all duplicate values. How can I return all duplicate values in one cell??
Thank you.
Asked
Active
Viewed 121 times
0
-
1What version of Excel do you have? – BigBen Jan 13 '21 at 15:15
-
I believe Excel 2013 – Jake Park Jan 13 '21 at 15:17