Avatar of marrowyung
marrowyung
 asked on

compare excel column

hi,

if I want to compare the same column name of 2 x excel, to see what is the different between 2 x files, what should I do ?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
marrowyung

8/22/2022 - Mon
Louis LIETAER

Yes, but what differences you want to highlight ?
marrowyung

ASKER
on the SAME column of diff excel, what is missing/addition from the other one.
ASKER CERTIFIED SOLUTION
Saqib Husain

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
marrowyung

ASKER

type =
select row2 in file1column1
again type =
select file2
select row 2 of file2column2

type all these in the row 2 of column 3?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
marrowyung

ASKER
any utilites can do this ?

Saqib Husain

Yes

marrowyung

ASKER
which one? I am checking out windiff, can't !

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
marrowyung

ASKER
/FYI, the same column of both excel has different length !

marrowyung

ASKER

If you do it a few times then you would become comfortable.

I agree ! but how ?
marrowyung

ASKER
should I sort both column in the same order first then compare based on this ?


Your help has saved me hundreds of hours of internet surfing.
fblack61
Saqib Husain

You can make it a tad bit simpler if you lay out both files such that they are both visible on the screen at the same time.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Saqib Husain

should I sort both column in the same order first then compare based on this ?

If they are not already so and you need them to be then Yes.
 
marrowyung

ASKER

=IF(A1=[file2.xlsx]Sheet1!$A$1,TRUE,FALSE)

"file2.xlsx" this is the full name of second file ?
I copied the same colujmn from other excel to the same excel side by side now, what should I do ?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Saqib Husain

I copied the same colujmn from other excel to the same excel side by side now, what should I do ?
Do you want to compare "row by row" or "each cell with the rest of the other column"?
marrowyung

ASKER
"each cell with the rest of the other column"?
Saqib Husain

Ok, now let's assume that: 
- your two columns are A and B
- column C is empty
- your data starts in row 2
- your data ends in row 7

Then enter this formula in C2
=IF(ISERROR(MATCH(B2,$A$2:$A$7,0)),"Not found","Found on row "&MATCH(B2,$A$2:$A$7,0))

Open in new window

copy the formula down to row 7

Note:Change the number 7 in the formula to whichever row is the end of your data. There are two instances of 7 in the formula.

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
marrowyung

ASKER
so must use formula ? no GUI predefined button for that ?

Saqib Husain

You have not given any requirement. Formula is one of the ways.

If you have something else in mind then you should specify it so that you may be helped accordingly.

Did you try the formula?
marrowyung

ASKER
what I meant is, if there are something much easier, I'd like to try.

I can't see why some one here keep saying just make use built in excel function and it can be done.


Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Saqib Husain

You did not answer my question. Did you try the formula I gave you?
Saqib Husain

Honestly, I would recommend a Delete.

There is no sample data. No real information on the question's requirement. Answers are all beating about the bush.
marrowyung

ASKER
I might come back later for this as I need a more full test!

tks for it and sorry about the late close as I am busying on another project.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes