Results location...

  • Thread starter Thread starter SCW
  • Start date Start date
S

SCW

The following function shows me the highest score from a large range of
columns/rows:

=LARGE(($B$13:$B$78,$N$13:$N$78,$F$13:$F$78,$J$13:$J$78,$R$13:$R$78,$V$13:$V$78,$Z$13:$Z$78),1)

How can I get the cell location of this result?

Thanks
g
 
Use Conditional Formatting with the formula =cell=cellwithformula.

David Hager
Excel FMVP
 
Back
Top