R
R
Rushack2021-11-28 18:04:45
Google Sheets
Rushack, 2021-11-28 18:04:45

How to glue two columns without repeats?

There are two columns with full names from different uploads
. One is missing the last name from the second, but both have repetitions.
It is necessary to add the missing ones to the first column, excluding repetitions (but what if there are namesakes)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-11-28
@Rushack

=uniqie(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