Excel Forum
Similar Content
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...

Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text)

See a formula to compare two list of numbers and see what happens (and how to solve it) when one list is numbers (aligned right) and the other list is numbers as text (aligned left). See:
1) Text To Columns keyboard shortcut Alt + D = E + F (2003) or Alt + A + E + F (2007 2010)
2) See formulas addition to convert the numbers to text so that comparison text to text can be made.
3) Formula with MATCH and ISNUMBER functions (Logical Formula).
4) Learn about how Excel sees numbers and text as different data types and thus 102 does not equal "102".

Download file: http://people.highline.edu/mgirvin/

Got a Question? Ask it Here in the Forum.