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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automating a computation process 3
Max Value in a Row 6
Lookup value that falls between two values in a range and then som 2
date function 10
How To Grade 40 Students relitively On a Normal Distribution. 0
RANK based on result and average 5
Count text cells if condition in row is true, over many rows. 0
Transposing in groups of rows 2

Top