LARGE to corresponding text value

M

Moni

In using this worksheet function
"=LARGE(('FY04'!W2,'FY04'!T16,'FY04'!N27,'FY04'!N39,'FY04'!
Q54,'FY04'!N66,'FY04'!Q77,'FY04'!K114,'FY04'!H128,'FY04'!
T168,'FY04'!N181,'FY04'!K192,'FY04'!D182),1)" - I would
like to know which cell, not the value, was chosen. Then
I would like to retrieve the text of that row, column 3.
Any ideas? Is that possible?
 
D

Don Guillett

Change this from b2,b6,etc to suit your ranges and your sheet.

Sub getlargeinfo()
With Sheets("FY04")
x = Application.Max(Range("b2,b6"))
'or
'x = Cells.Find(Application.Large(Range("b2,b6,etc"), 1))
Application.Goto Cells.Find(x).Offset(, 3)
End With
End Sub
 

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

Location of Large 1
Cell Location of LARGE response 0
IF column contains certain text return value of corresponding row 7
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Looking up a value in column to return corresponding text on value 1
Large Function returning top values 8
Bit of a complex SUM 4
How to find the first row not equal to the value in the first row? 8

Top