Excel Forum

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.