How to match or compare row wise between two excel files.

0

Entering edit mode

2.7 years ago

alvea.tasneem • 0

Hello,

I have two different excel sheets (each have a single column) containing two different data sets respectively, I need to match or compare these two datasets row-wise. Which excel command would help me fulfil this task? At the same, are there any other programming language or linux commands that can make this task easier?

P. S. The two datasets that I have to compare have nearly 20,000 rows each.

Thank you for your consideration, I look forward to you kind help.

Sincerely, Ms. Alvea

excel matching row-wise datasets • 778 views

ADD COMMENT • link updated 2.7 years ago by Joe 21k • written 2.7 years ago by alvea.tasneem • 0

1

Entering edit mode

are there any other programming language or linux commands that can make this task easier

Yes. awk, sed, grep, perl, Python, R -- all of these will likely be more useful in those circumstances. If you want more specific help, you'll have to more specific about the tasks you want to achieve and what you've tried already.

ADD REPLY • link 2.7 years ago by Friederike 9.0k

1

Entering edit mode

you can use either vlookup or if function in excel, for comparison. If you can post data (not images), some one here will be able to help addressing the issue.

ADD REPLY • link 2.7 years ago by cpad0112 21k

0

Entering edit mode

This is pretty much exactly what the tool join is intended to do.

ADD REPLY • link 2.7 years ago by Joe 21k

Login before adding your answer.