Solved

# Equal values in different fields in Excel

Posted on 2011-03-11
Medium Priority
554 Views
I have two different Excel sheets. I have copied all the columns of one into another and now I want to run a formula to check if the values of one column equal the other. No matter what formula I use, Excel is not recognizing the values of one of the columns as equal to the other.

For example, is not recognizing that  ICF13X13P= ICF13X13P. I have formatted both columns as text and it still doesn't recognize them.

Any ideas? Thank you in advance.
0
Question by:poemorella
• 2
• 2

LVL 24

Accepted Solution

jimyX earned 2000 total points
ID: 35111265
I have match here?
Match-Columns.xls
0

LVL 19

Expert Comment

ID: 35111335
You might need to use the TRIM function to ensure that there are no hidden spaces in your cell.

=TRIM(A3)=TRIM(B3)

Sincerely,
Ed
0

Author Comment

ID: 35111919
How exactly is that formula used? When I run it in column C I just get a 0.

Thanks.
0

LVL 24

Expert Comment

ID: 35112735
0

Author Closing Comment

ID: 35141341
The table was still not recognizing the cells are equal when two different type tables where compared (xls and cvs). However, this formula is the correct one to find a match.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
###### Suggested Courses
Course of the Month9 days, 5 hours left to enroll