Videos tagged with consolidate
Yet another solution to matching data from two different worksheets...the Data Consolidate command. Episode 929 shows you how.
The Consolidate command is versatile. In Episode 832, see how to use Consolidate to summarize similar data that occurs on multiple worksheets.
During a recent seminar, someone asked me to show the audience how to use the Consolidate command. I launched into the technique shown in Episode 831 - using consolidate to collapse a single range down to one line per customer. In tomorrow's podcast, we will look at alternate uses for consolidate.
A question from a seminar... how can you use the consolidate command to subtract one data set from another data set? Episode 787 shows you the workaround.
An introduction to using Data Consolidate to add two data sets. Episode 786 introduces the concept. Tomorrows episode will throw in an interesting twist.