frustrating beyond belief!: trying to compare two lists of URLs

cachaco · #1 08-25-2015, 12:07 AM

so Ive tried multiple solutions from google, and every time I get the same error, Im beginning to think something is wrong with my excel (professional plus 2013)

Im trying to compare two columns of URLs so excel tells me which URLS arent repeated in both columns or which are on both columns, either way would be useful. Tried several different formulas but after I typed them always get the same error (pic below) Wasted hours and failed so I need your help, thanks

macropod · #2 08-25-2015, 06:06 AM

You could use:

Code:

=COUNTIF(A2,D:D)

which will return the number of matches, not just a true/false result.

NoSparks · #3 08-25-2015, 08:10 AM

A Google search returned this site which made me think trying this might work. Was unable to test it on your picture.

Code:

=IF(ISERROR(NOT(MATCH(A2,D:D,0))),A2,"")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very frustrating spell check problem	Biederboat	Office	3	03-20-2016 09:58 AM
Conditional Formatting to compare lists and order	SarahBear	Excel	4	07-09-2014 09:40 AM
Frustrating paragrah spacing problem in Word 10	provlima	Word	1	12-30-2012 11:52 AM
URLs in citations	acappella	Word	3	07-24-2012 03:28 PM
Using COMPARE to compare more than two variables	Wyskers	Word	1	12-03-2011 01:37 AM