Hello,

I am in need of help with a set of data. I am attaching an example set of data that reflects the real formulas needed. I have a list of accounts in column A and some data the follows. I need formulas that I am able to copy all the way down without starting over at each new unique account. Please see attached where I try to clearly describe the formula needed.

Thanks for your help!

matthew.murphy102@gmail.com

Excel Help.xlsx