locked
Wondering about a simple function that excel should have RRS feed

  • Question

  • how can a cell reference itself to find the name of the page it is on

    I numbered my pages and i am trying to get the cell to reference itself for the sheet name (which is a number) and minus 1 from it to get the sheet name(which is a number) of a previous page?

     any clue on how this can be done

    Monday, April 7, 2014 4:01 AM

Answers

  • The formula

    =REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

    returns the sheet name. So if that is a number,

    =REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")-1

    returns "sheet name minus 1".

    Remark: this only works if the workbook has been saved, not in a newly created workbook that has never been saved yet.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Monday, April 7, 2014 4:30 AM