Need help with SMALL and it's sheet reference

  • Thread starter Thread starter Leatherfoot
  • Start date Start date
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
 
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)
 
: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
 
: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
 
Back
Top