How to match or compare row wise between two excel files.
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
• 1,494 views
•
link
updated
by
Joe
•
written
by
alvea.tasneem •
•
written
by
alvea.tasneem •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Batch effect correction to compare differentially expressed genes across datasets
written by mmitra •
-
Fisher exact test in R package
written by Nuglozeh •
-
How to write it in R language?
written by Farah
-
How to check for the presence/absence of unique rows in two different matrices?
written by mario.red8976
-
Are there any functions to subtract all features(rows) to a particular value(row) in the same data …
written by mohammedtoufiq91
-
Demultiplex fastq miseq reads
written by bishnuadhikari323 •
-
common data extraction
written by Azhar •
-
cluster groups of values disregarding specific sequence of values
written by mccormack •
-
Differential Analysis Of Proteomics Data
written by Assa Yeroslaviz
-
How Do You Align Or Compare Two Networks Content-Wise?
written by Michi
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.
you can use either
vlookuporiffunction in excel, for comparison. If you can post data (not images), some one here will be able to help addressing the issue.This is pretty much exactly what the tool
joinis intended to do.