A data tool used to summarize and merge data from multiple ranges or worksheets into a single master worksheet.
جرّبه بالذكاء الاصطناعيThe Consolidate feature allows you to aggregate data from different sources using functions like Sum, Count, or Average. It creates a consolidated table that updates based on the source ranges, making it ideal for combining monthly reports or departmental budgets.
If you have sales data for three different regions on separate sheets, you can use Consolidate to sum the total sales for each product into one summary sheet.
Only if you check the 'Create links to source data' option; otherwise, you must re-run the tool to refresh the results.