3-d array function

[rk1]

Hi there,

I have a workbook with 50 identical worksheets. Each sheet represents
different person (name of person is in a cell of every worksheet), bu
all other cells are identical. I created a summary sheet where I di
pick the 3 highest scores of the same cell in every worksheet (larg
function). I would like to put the name of the person reaching thi
score into the adjacent cell, but can't find how to do that.

Any help greatfully appreciated



Reine

 

[Frank Kabel]

Hi
You may also 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.
- your value is in cell A1
- the name of the person is in B1
- on your summary sheet the value to look for (e.g. the
highest value calculated with a large function) is in A1.
Enter the following in B1 of your summary sheet
=VLOOKUP(A1,THREED('sheet1:sheet50'!$A$1:$B$1),2,0)

This should work (not tested though)