Upgrading Excel tools

Import data from other files

January 25, 2021

Import data from other files

January 25, 2021
  • Flash Fill with formulas – Column From Examples
  • “Vlookup” for several parameters – Outer Joins
  • “Vlookup” omitting all non found – Inner Joins
  • “Vlookup” that returns only missing values – Anti Joins
  • Advanced text formatting