Start Free Trial

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 ?

Yes, but what differences you want to highlight ?

ASKER

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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?

ASKER

any utilites can do this ?

Yes

ASKER

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

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

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

ASKER

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

I agree ! but how ?

ASKER

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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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.

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 ?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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

ASKER

"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

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

ASKER

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?

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.

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.

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.