The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

Excel remove duplicates | How to summarise list from two sources

by admin | Jul 10, 2013 | Excel | General, Excel | Intermediate Lessons, Excel | Useful tricks

I was recently doing some training and one of the issues that came up was that the user had the following problem: Two stock lists (identical items), two physical locations and he needed to get a summary that showed the total number of items. I first thought about...

Excel shortcut keys – FREE

Recent Posts

  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management

Like Excel Expert on Facebook

Recent Posts

  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved