How to compare two columns with urls in excel?

R

R

random_object2019-05-23 12:08:25

excel

random_object, 2019-05-23 12:08:25

How to compare two columns with urls in excel?

Hello. The report has two columns with similar URLs, Task. Compare which urls from the 2nd column are missing from the first

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

V

Valery, 2019-05-23
@Desay

VLOOKUP?
https://support.office.com/en-us/article/%D0%92%D0...

A

akelsey, 2019-05-25
@akelsey

I would use =match(A1,B1:B55,0).
Next filter by n/a

Similar questions

A

asizhuk2019-07-24 18:01:58

nodejs, exceljs. Checking if merged cells intersect horizontally? 0Reply

K

Kotar4ik2021-03-04 16:06:48

What is wrong with VBA macro processing cell array? 1Reply

A

Alexey Povolnov2017-03-10 17:26:40

How to fulfill the condition? 1Reply

P

Pithagoras2017-03-11 23:52:41

How to write a desktop application like Excel, C#, cross-platform? 1Reply

D

Dima Melnyk2017-03-12 22:20:44

How to add a matrix to an Excel file in Java? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question