Display the address of cell with max value
Hi.
I have a range of cells from A1 thru D1 with a total of A1:D1 in E1 and a
total to compare that to in F1.
I want to take the difference between E1 and F1 and add it to the cell
between A1 and D1 that has the largest value.
Any ideas how I might accomplish this?
Thanks!
|