Disarmonious
Board Regular
- Joined
- Oct 31, 2016
- Messages
- 139
Hello, what formula would I use to have cell H1 display the date in which an employee was the most productive for the month. I have a "Date" column (A1) that the user will enter the current date below per day. There are 3 other "catagorized" columns (cells B1, C1, D1) that will keep track of how many assignments have been completed per day for the month. Column E displays the total amount of assignments completed for the current date for the month. I want cell H1 to ONLY display the most productive date for the entire month. |
<tbody>
</tbody><colgroup><col><col><col span="8"></colgroup>