Displaying sheet and cell value in another cell
 

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 ?
--
MB

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:X 10&"'!A1:A10"),A1)0,
0))

--
Regards
Frank Kabel
Frankfurt, Germany

"M. Beall" schrieb im Newsbeitrag
...
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 ?
--
MB