+ Reply to Thread
Results 1 to 2 of 2

Call the Sheet name

  1. #1
    Forum Contributor
    Join Date
    06-30-2008
    Location
    PSL, FL
    Posts
    271

    Call the Sheet name

    guys,

    I have this

    =MIN('Week 1a:Week 26b'!I13)

    This calls a number which works perfect

    How can I do the same thing but call just the sheet name?

    Because really what I want is

    For Example L6 to show the min number and M6 to show what sheet it came from?

    Matt

  2. #2
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Call the Sheet name

    =MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,1024)

    Oops. I misread your post. The above formula will give you the sheet name from a direct cell reference. I am not sure how to incorporate a min function into it. Give me some time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1