LARGE to corresponding text value

  • Thread starter Thread starter Moni
  • Start date Start date
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?
 
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
How to conditionally sum values depending on values in other colums 2
IF column contains certain text return value of corresponding row 7
Return Numeric Value to their Matched Value Position in Single Column 3
Large Function returning top values 8
return multiple corresponding values using INDEX 2
Function to find 'n'th largest alphanumeric field (like "Large") 8
Auto number Non null values 6

Back
Top