Excel function to return tab name
 

I have a spreasheet with multiple tabs. I am getting the maximum value
of a table in a summary tab. The table is present in each tab with
different values. I would like to know if there is a way to know from
which tab that maximum value came from. (since the table is present in
tab1, tabb2 , tab3 for example and the max comes from tab3, how can I
know without going through each tab myself, from which tab the value
came from?).
Thanks for your help.


--
masoud12345
------------------------------------------------------------------------
masoud12345's Profile: http://www.excelforum.com/member.php...o&userid=32622
View this thread: http://www.excelforum.com/showthread...hreadid=524217

Excel function to return tab name
 

I would use a helper table on a separate worksheet.

I'd put the names of the worksheets in column A and formulas like this in column
B:

=max(tab1!a1:z99)

Then I'd use a formula like this to get the name:

=index(a:a,match(max(b:b),b:b,0))

(say in C1 of that same helper sheet)

masoud12345 wrote:

I have a spreasheet with multiple tabs. I am getting the maximum value
of a table in a summary tab. The table is present in each tab with
different values. I would like to know if there is a way to know from
which tab that maximum value came from. (since the table is present in
tab1, tabb2 , tab3 for example and the max comes from tab3, how can I
know without going through each tab myself, from which tab the value
came from?).
Thanks for your help.

--
masoud12345
------------------------------------------------------------------------
masoud12345's Profile: http://www.excelforum.com/member.php...o&userid=32622
View this thread: http://www.excelforum.com/showthread...hreadid=524217

--

Dave Peterson