(This Working Droid) This Working Droid Episode 173 Excel Lists

Episode Guide

  • Create detailed yet unique identifiers
  • Add data as need to complete table
  • Add auto-filter or customer filters if not all columns needed
  • Sort by name, date, or any other label
  • Filter data to create custom list
  • Copy filtered data into new sheet
  • Use master table to find matches in other sheets