Reference the worksheet from a multiple worksheet range function (
I want to reference the worksheet that is returned when I do a 3-D reference
function.
For example:
If on worksheet "1" of 40 I have this formula:
=MAX('2:40'!I4)
It will return the maximum value, but I need to know which worksheet had the
maximum value. Suggestions? Please?
|