N
N
Noir2019-05-22 18:07:18
Google Sheets
Noir, 2019-05-22 18:07:18

How to find those elements that are missing in another column?

here is an example + the number of elements in the columns is different
5ce5658eeeb4e775255692.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dollar, 2019-05-22
@PolarBearGG

You need to make a separate function using Google Script, and use it in your table. Then in a separate column you can display whatever your heart desires.
But it's easier to colorize the elements in column B that are missing in column A . Will this fit? COUNTIF function

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question