Find a min/max value in a worksheet

[quinbe]

Hi all,
I have been able to get the maximum value in a WORKSHEET by using LARGE(array,k). However, I could not find the specific cell where the value locates.
Can any one help me here?
Thanks

QB

 

[SkipVought]

Use a lookup function like MATCH

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[gizmo1973]

or RANK

Regards, Phil.

I'm here beacause I LOOK busy

"Where there's blame there's DPlank"

 

[GlennUK]

I'd use conditional formatting, as that will highlight cells when there are more than one occurence of the max value in a range.

Select the range, then do menu command Format/Conditional Formatting/Formula Is:
=A1=MAX($A$1:$K$25)
and click the Format button to choose a suitable format for highlighting the matches.

Adjust the range refences in the formula to suit your data ... A1 being the active cell ( first cell of selection ), and $A$1:$K$25 being the absolute reference of the data range.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.