View Single Post
  #1   Report Post  
Liz C
 
Posts: n/a
Default 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!