Ok, I'm on a work program, so I can't download anything

I'm trying to just paste 2 lists that should be identical and find out which numbers don't match up.

I'm wondering if there is a way to find out which horizontal cells don't match up

Example:

a a
b c <- highlight these two lines
c b <-
d d
e e

Working with 250-450 lines a night, so it would be awesome if I could stream line it somehow.

they're both numbers?

i dont know much about excel, so this is what i'd do.

wlog suppose they're in columns A and B. in column C, set it equal to the formula =A1-B1

if C is 0, they're the same, if C is not zero, they're different. you can then do a filter on C for non-zero values to see just the columns which are different.

/edit: from a quick google search http://superuser.com/questions/289650/how-to-compare-two-columns-and-find-differences-in-excel

This post was edited by carteblanche on Aug 5 2015 07:24pm

That's really clever, but won't work in my situation

They are labeled EDxxxxxx (x being a group of numbers) in my spreadsheet, I should have been more specific

did the link not help?

you can still use my method. just substring the ED out so that they're numbers if they're all prefixed with ED

Worked like a boss, thank you so much

My coworkers gonna love it