Comparing values

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I have two columns with wth values i want to compare the two values each every value of the column 1 with the values in column two if the value is available i want it to be put on th3 third column.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
use some modification of this formula

=IF(ISNUMBER(MATCH(B2,C:C,0)),B2,"")
and copy it down

in this case the words are in column B and C