return a cell contents as the result of usiing "small"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to return the contents of a cell located above a cell returned
from the "small" function...into the cell located next to the cell which
contains the "small" function....help!
 
Hi,

How about something like:

=INDEX(A:A,MATCH(SMALL(A1:A100,3),A:A,0)-1)

where A:A is the evaluated column and A1:A100 is the evaluated range

Regards,
KL
 
You must log in or register to reply here.

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

Can UDF return a customized hyperlink? 3
VLOOKUP return cell location and hyperlink 0
Return cell characters after space 2
Search for specific text within last non blank cell in a range 2
Lookup returning wrong results 0
Excel Displaying content from excel sheet onto textbox in userform 0
Return Results of a cell based on cell referenced in a cell 4
Totalling seperate cells from a HLOOKUP function 8

Back
Top