Our software is producing a report that has multiple rows for each employee.
I need to generate a report with a single, summed row for each employee.
I've attached a very simplified workbook.
Our software is producing a report that has multiple rows for each employee.
I need to generate a report with a single, summed row for each employee.
I've attached a very simplified workbook.
Last edited by GigG; 04-07-2020 at 04:46 PM.
Moved to thee Mac section.
What a shame you have a Mac! This would have beeen a cinch with PowerQuery.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Any way you could move it back? It doesn't seem to be getting any traction here.
Edit Please disregard. See next post.
Please try this formula in D15 and fill down.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 04-06-2020 at 04:20 PM.
Dave
Will return unique 'EE ##' numbers. In A15 and filled down.In B15 filled down and acrossFormula:Please Login or Register to view this content.Then again in D15 and filled down.Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Pfft!! I overlooked the 365 in your profile. For the unique 'EE ##' eplace the AGGREGATE/FREQUENCY formula withFormula:Please Login or Register to view this content.
I failed to mention to fill the 'names' formula across just to column C. My apologies. The 'amount totals' formulagoes in cell D15 and filled down. I get this at my endFormula:Please Login or Register to view this content.
A B C D 14 Result 15 12705555 Bob Smith 1253 16 12704444 John Doe 839
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks