What do you mean by consolidating data? Write the options available in
consolidate dialog box.
plz tell answer for me ...
Answers
Answered by
5
Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily
Answered by
8
If you have a group of tables (or lists) it is possible to combine (or consolidate) all this data into one table (or list). This can be done using the (Data > Consolidate) dialog box. You can use (Data > Consolidate) to combine the corresponding values in up to 255 different worksheets into a single worksheet.
Similar questions
English,
1 month ago
Business Studies,
1 month ago
English,
2 months ago
Hindi,
2 months ago
Business Studies,
7 months ago
English,
7 months ago