mr_ITtoyou
New Member
 Joined
 Mar 26, 2021
 Messages
 31
 Office Version

 2016
 Platform

 Windows
I have a spreadsheet for call center agents' call stats with 12 months. I have a cell, far right, column DF, (Average Call Per Hour). Below the spreadsheet, I have a formula that calculates the Average calls per hour, Year To Date, for each month, Row 3541. My question is, is there a formula that would place the latest result from each month, Row 3541 to be placed in the cell DF 410. To clarify, (I hope), after entering the data in Jan. the calculated resaults will be in Column F3541 and then those results will be placed in the Average Call Per Hour, DF 410. Then after the data is entered the results for Feb. will be placed in Average Call Per Hour, DF 410, override Jan. results, and so on for each month. Is there a formula for DF 410, if Feb P 3541 is greater than Jan. F 3541 then enter Feb. results?
The file XI2bb would keep freezing when I pressed Mini Sheet Capture, so I placed a link with the Excel spreadsheet. Thanks in advance for any help on this.
The file XI2bb would keep freezing when I pressed Mini Sheet Capture, so I placed a link with the Excel spreadsheet. Thanks in advance for any help on this.
Excel Agent call Spreadsheet  Google Drive
drive.google.com