Session
2017 APP2P Conference Sessions
Excel Files
- Is VLOOKUP Still the Champ?: VLOOKUP_Champ_Workbooks
- How to Prepare Data without Formulas or Macros: PrepareData
Related Blog Posts
- VLOOKUP and Wildcards
- Remove Extra Spaces from Lookup Values with TRIM
- Multiple Condition Summing in Excel with SUMIFS
- SUMIFS with OR
- Multi-Column Lookup with VLOOKUP and SUMIFS
- Get & Transform: An Alternative to Manually Flattening Data
- Get & Transform: An Alternative to Finding the Last Delimiter with Formulas
- Get & Transform: An Alternative to Reformat Macros
- Unpivot Excel Data
- Get & Transform: An Alternative to Copy Paste Append
- Use Get & Transform to Reconcile Two Lists
- Get & Transform: An Alternative to VLOOKUP List Comparisons
Subscribe to the Excel University blog