Displaying sheet and cell value in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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))
 
You must log in or register to reply here.

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

Help to create a macro 2
modify all formula references in multiple cells 3
formulae in excel worksheets 4
Populate Data from Summary Sheet 5
Automatically update excel worksheet formula 7
Copy Sheet #'s, but leave cell reference 3
Conditional Formatting Minimim Value 2
MAX across worksheet, return text value 8

Back
Top