L
L
Lynatik0012021-10-18 20:37:48
Google Sheets
Lynatik001, 2021-10-18 20:37:48

How to check for identical values ​​- from 2 columns?

How can I compare 2 columns for matches, and in the neighboring one - opposite the cell where there is no match, what would write no match?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-10-18
@ProgrammerForever

=arrayformula(если($A:$A=$B:$B;"";"нет совпадения"))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question