Excel Weekly Results Consolidation
Budget: $10 – $30 USD
I have two worksheets—“Week 1” and “Week 2”—that list participant names with their respective results. The name lists don’t perfectly overlap, so I need a clean, merged summary sheet that does the following:
• Builds a single column of all unique names, keeping people who appeared in only one week.
• Adds three adjacent columns: “Week 1”, “Week 2”, and “Total”. Week-specific columns should pull or reference the original figures, leaving a zero or blank where someone was absent. The “Total” column must calculate the sum of the two weeks for every individual.
• Ensures formulas recalculate automatically if I update either source sheet.
You’re free to use standard Excel tools—INDEX/MATCH, XLOOKUP, Power Query, or a simple macro—so long as the final workbook contains the original two sheets untouched and one new summary sheet that meets the points above. Accuracy is critical; a quick spot-check against my sample numbers should match 100 %.
• Builds a single column of all unique names, keeping people who appeared in only one week.
• Adds three adjacent columns: “Week 1”, “Week 2”, and “Total”. Week-specific columns should pull or reference the original figures, leaving a zero or blank where someone was absent. The “Total” column must calculate the sum of the two weeks for every individual.
• Ensures formulas recalculate automatically if I update either source sheet.
You’re free to use standard Excel tools—INDEX/MATCH, XLOOKUP, Power Query, or a simple macro—so long as the final workbook contains the original two sheets untouched and one new summary sheet that meets the points above. Accuracy is critical; a quick spot-check against my sample numbers should match 100 %.