Need help with SMALL and it's sheet reference

L

Leatherfoot

I am wondering if it is possible to get the contents of a cell in th
same worksheet as the following SMALL formula. I need cell D13 from th
same worksheet out of 20 sheets that this function finds has th
smallest number.

=SMALL(Race1:Race20!E13,1
 
F

Frank Kabel

Hi
You may try to download the free add-in
Morefunc.xll (http://longre.free.fr/english). The function
THREED converts a 3D array to a 2D array.
e.g. Enter the following formula
=INDEX(THREED(Race1:Race20!D13),MATCH(SMALL(Race1:Race20!E13,1),THREED(
Race1:Race20!E13),0))

(not tested though as I don't have Morefunc.xll installed on my work
PC)
 
L

Leatherfoot

:eek: That worked perfectly just as you typed it! Thank you so much
You have no idea how much this helps me with this project. Thank
again
 
L

Leatherfoot

:eek: That worked perfectly just as you typed it! Thank you so much
You have no idea how much this helps me with this project. Thank
again
 

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

display Column Header based on cell value in a range 2
Needs help combining functions. 3
Need formulas for searching for a value in a table and returning row/column name 7
How do you make a summary sheet? 0
trouble with (complicated) vlookup searching another workbook 2
copy specific cells from sheets if the information is correct 3
Match issue 3
Excel formula help for calculating freight. 2

Top