Results location...

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
 
D

David Hager

Use Conditional Formatting with the formula =cell=cellwithformula.

David Hager
Excel FMVP
 
Top