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 ?
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.
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.
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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.
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?
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.
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.
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.
tks for it and sorry about the late close as I am busying on another project.