Display Date If...

[Disarmonious]

[TABLE="width: 721"]
<tbody>[TR]
[TD="colspan: 10"]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.[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody><colgroup><col><col><col span="8"></colgroup>[/TABLE]

 

[wideboydixon]

=INDEX($A:$A,MATCH(MAX($E:$E),$E:$E,0))

Written by hand and untested :-O

WBD

 

[Disarmonious]

Hello,

You'll have to be patient with me as I try to get this to work. Is this a VB code, where I select "Visual Basic" and then copy and paste this? I tried doing this, just in case, and nothing happened. I then copied and pasted this into the cell's formula bar, and got an error "#N/A". Since I want the date to appear in H1, I don't see where the coding that you sent "tells" cell H1 to display the date? Is there a simpler formula I could type in cell H1? Keep in mind that the user is entering a "short date" every day. For example: User types 4/16/18 for today's date, and he finished with 112 assignments, but on the day before (4/15/18), he finished with 127 assignments. I would like the date "4/15/18" to appear in H1. Again, if your suggestion works, I'm sorry for the reiteration, but I didn't get the result I was looking for...

=INDEX($A:$A,MATCH(MAX($E:$E),$E:$E,0))

Written by hand and untested :-O

WBD

 

[wideboydixon]

Hmmm. It shouldn't give #N/A:

Book1
	A	B	C	D	E	F	G	H
1	01/01/2018	1	6	1	8			02/01/2018
2	02/01/2018	2	5	6	13
3	03/01/2018	3	4	2	9
4	04/01/2018	4	3	5	12
5	05/01/2018	5	2	3	10
6	06/01/2018	6	1	4	11
Sheet1

Cell Formulas
Range	Formula
H1	=INDEX($A:$A,MATCH(MAX($E:$E),$E:$E,0))

WBD

 

[Disarmonious]

Hey, thank you for your suggestion. It's working out for me. The problem I was having is that I had merged cells for all of my columns, so I tweaked this particular sheet to single cell columns. Thanks again!