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

V

Vidog2012-02-13 06:20:21

API for office applications to the site 1Reply

L

Lulzsec2015-11-12 14:53:59

Google Docs distorts the file, increasing its size. Why and how to fix? 1Reply

V

Valera Karmanov2020-05-11 22:10:51

How to create column names using alphabet? 1Reply

E

Erik Mironov2021-07-19 17:42:45

Java or Php library for generating Excel contract forms from a template? 2Reply

E

Eugene2015-11-20 13:26:05

How to delete rows in Excel that match a rule? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question