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 ?

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

Yes, but what differences you want to highlight ?

on the SAME column of diff excel, what is missing/addition from the other one.

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

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

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

any utilites can do this ?

Yes

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.

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

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

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

I agree ! but how ?

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

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.

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

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.

=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.

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

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"?

"each cell with the rest of the other column"?

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

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.

- 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))
```

copy the formula down to row 7Note: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

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

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?

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

Did you try the formula?

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.

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.

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

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.

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

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.

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