Excel remove duplicates | How to summarise list from two sources

Published: Fri, 07/12/13


The Excel Expert
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users


Excel remove duplicates | How to summarise list from two sources- 2013-07-10 15:51:34-04

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 subtotals but when I actually tried it, [...]
Read more...