excel in courses - Data Consolidation

Hi Ami-du

Thanks for your question.

The answer depends on how the data you want to consolidate is arranged.

Examine your data and decide whether to consolidate it with 3-D references in formulas, by position, or by category.
Formulas: You can use 3-D references in formulas for any type or arrangement of data. This is the recommended method.

Position: If you're planning to combine data that's in the same cell in each of several ranges, you can consolidate by position.

Category: If you have several ranges with different layouts, and you're planning to combine data from rows or columns that have matching labels, you can consolidate by category.

As this would be a long answer if I explained each option, I would suggest looking up consolidation in Excel Help, as you will need to decide which of these options best suit the data you have.

Amanda