Dear experts,
Need help with comparing 2 columns.
Column A must be compared with Column C and the string that's in both the Columns must be the output.
Please see below. Since this is in words/alphabets I'm facing the problems writing it.
Any help is greatly appreciated.
A
xyz-abc-q
xyz-abc-c
xyz-abc-d
xyz-abc-g
xyz-abc-p
C
xyz-mnk-y
xyz-abc-i
xyz-abc-k
xyz-abc-o
xyz-abc-c
xyz-aoc-g
xyz-adc-g
xyz-abc-c
xyz-cbc-n
xyz-abc-q
xyz-abc-l
xyz-abc-b
xyz-abc-n
xyz-abc-m
Need help with comparing 2 columns.
Column A must be compared with Column C and the string that's in both the Columns must be the output.
Please see below. Since this is in words/alphabets I'm facing the problems writing it.
Any help is greatly appreciated.
A
xyz-abc-q
xyz-abc-c
xyz-abc-d
xyz-abc-g
xyz-abc-p
C
xyz-mnk-y
xyz-abc-i
xyz-abc-k
xyz-abc-o
xyz-abc-c
xyz-aoc-g
xyz-adc-g
xyz-abc-c
xyz-cbc-n
xyz-abc-q
xyz-abc-l
xyz-abc-b
xyz-abc-n
xyz-abc-m