Displaying sheet and cell value in another cell

M

M. Beall

I am using the Min formula to find the minimum value from tables on seperate
worksheets.
The summary sheet displays the minimum value.
Is there a way to indicate on the summary sheet, from which sheet that the
min value was selected from ?
 
F

Frank Kabel

Hi
using an approach from Harlan Grove try the following:
1. put the names of all your sheets in a range of your summary page.
e.g. in the cells X1:X10
2. In A1 put your MIN formula (I assume your values are in A1:A10 on
all sheets)
3. Now use the following array formula (entered with CTRL+SHIFT+ENTER)
=INDEX(X1:X10,MATCH(TRUE,COUNTIF(INDIRECT("'"&X1:X10&"'!A1:A10"),A1)>0,
0))
 
Top