G
G
Geezer172021-02-19 07:42:00
Google Sheets
Geezer17, 2021-02-19 07:42:00

How to find differences in two Google Sheets columns and output them?

There are two columns with text lists. You need to find in the first column the values ​​that do not repeat in the second, and in parallel find the values ​​from the second that do not repeat in the first. That is, find the differences in the lists. Then you need to display the result in a separate range of cells - the found unique values ​​from the first list in one column, and from the second - in the second:
602f427dba7cf103493658.jpeg
I tried to do everything using conditional formatting with a formula
=СЧЁТЕСЛИ($A:$B;A1)<2
, followed by filtering the list by fill color, but this takes a lot of manual work . Is there a way to implement this in some other way with a filter formula or something similar?
Thank you in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2021-02-19
@Geezer17

602fbac69dfcc919430859.png
Formula in cell D =FILTER(A1:A11;ISNA(MATCH(A1:A11;B1:B12;0)))
Formula in cell E =FILTER(B1:B12;ISNA(MATCH(B1:B12;A1:A11;0)))
Link to example

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question