My speadsheet looks like:
[TABLE="width: 1174"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Grade[/TD]
[TD]Week 1 Contribution[/TD]
[TD]Week 2 Contribution[/TD]
[TD]Week 3 Contribution[/TD]
[TD]Week 4 Contribution[/TD]
[TD]Total Contribution[/TD]
[/TR]
[TR]
[TD]Blackman[/TD]
[TD]Ciarra[/TD]
[TD]1st Grade[/TD]
[TD]$10.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$10.00[/TD]
[/TR]
[TR]
[TD]Olanipekun[/TD]
[TD]Oluwatoyin[/TD]
[TD]1st Grade[/TD]
[TD]$20.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$20.00[/TD]
[/TR]
</tbody>[/TABLE]
I have a cell using MAX function ie =MAX(I412:I488), I also want to display the last and first name of the person with the highest contribution in a new cell as well. Cant figure out how to do that.
[TABLE="width: 1174"]
<tbody>[TR]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Grade[/TD]
[TD]Week 1 Contribution[/TD]
[TD]Week 2 Contribution[/TD]
[TD]Week 3 Contribution[/TD]
[TD]Week 4 Contribution[/TD]
[TD]Total Contribution[/TD]
[/TR]
[TR]
[TD]Blackman[/TD]
[TD]Ciarra[/TD]
[TD]1st Grade[/TD]
[TD]$10.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$10.00[/TD]
[/TR]
[TR]
[TD]Olanipekun[/TD]
[TD]Oluwatoyin[/TD]
[TD]1st Grade[/TD]
[TD]$20.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$20.00[/TD]
[/TR]
</tbody>[/TABLE]
I have a cell using MAX function ie =MAX(I412:I488), I also want to display the last and first name of the person with the highest contribution in a new cell as well. Cant figure out how to do that.