Solved

Equal values in different fields in Excel

Posted on 2011-03-11
5
548 Views
Last Modified: 2012-05-11
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
Comment
Question by:poemorella
  • 2
  • 2
5 Comments
 
LVL 24

Accepted Solution

by:
jimyX earned 500 total points
ID: 35111265
I have match here?
Match-Columns.xls
0
 
LVL 19

Expert Comment

by:MINDSUPERB
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

by:poemorella
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

by:jimyX
ID: 35112735
Could you attach your sheet, or a sample of your data?
0
 

Author Closing Comment

by:poemorella
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question