We help IT Professionals succeed at work.

compare excel column

56 Views
Last Modified: 2020-09-27
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 ?
Comment
Watch Question

Louis LIETAERSystem Infrastructure Architect
CERTIFIED EXPERT

Commented:
Yes, but what differences you want to highlight ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
on the SAME column of diff excel, what is missing/addition from the other one.
Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
marrowyungSenior Technical architecture (Data)

Author

Commented:

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

type all these in the row 2 of column 3?
marrowyungSenior Technical architecture (Data)

Author

Commented:
any utilites can do this ?

Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
Yes

marrowyungSenior Technical architecture (Data)

Author

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

Saqib HusainEngineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
marrowyungSenior Technical architecture (Data)

Author

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

marrowyungSenior Technical architecture (Data)

Author

Commented:

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

I agree ! but how ?
marrowyungSenior Technical architecture (Data)

Author

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


Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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.
Louis LIETAERSystem Infrastructure Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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.
 
marrowyungSenior Technical architecture (Data)

Author

Commented:

=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 ?
Louis LIETAERSystem Infrastructure Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Louis LIETAERSystem Infrastructure Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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"?
marrowyungSenior Technical architecture (Data)

Author

Commented:
"each cell with the rest of the other column"?
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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))
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.

marrowyungSenior Technical architecture (Data)

Author

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

Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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?
marrowyungSenior Technical architecture (Data)

Author

Commented:
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.


Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
You did not answer my question. Did you try the formula I gave you?
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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.
marrowyungSenior Technical architecture (Data)

Author

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.