Download Excel Start File people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT715-721.xlsx
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: people.highline.edu/mgirvin/
- Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text) ( Download)
- Excel Magic Trick 717: List 2 Same Order as List 2 MATCH and ROWS functions ( Download)
- Excel Magic Trick #119: Is Item In List 2 Examples ( Download)
- Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas ( Download)
- Use the match function to find number in list in Excel ( Download)
- Excel Magic Trick 724: VLOOKUP Check If Quantities Are Equal In Two Lists Show Differences If Not ( Download)
- Excel - How To Compare Two Excel Sheets Using VLOOKUP - Episode 1343 ( Download)
- Comparing Two Lists in Microsoft Excel | Excel Nerds ( Download)
- Excel Magic Trick #245: Matching 2 Lists w IF & OR functions ( Download)
- Excel Trick - Quickly Compare Numbers ( Download)
- Text Compare add in for Microsoft Excel, compare two lists ( Download)
- Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice ( Download)
- Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method ( Download)
- Compare 2 Lists in Excel | Fastest Way!! ( Download)
- Using VLOOKUP instead of MATCH ( Download)
