• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Named Range Conflict?

Tech56

Member
Hello I am trying to use this formula to get the worksheet names in cell A1:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

It works for all sheets except for the Categories sheet. There is a named range in column A which I think is conflicting with the formula.

Can someone please check this?

Thank you very much
 

Attachments

  • Money Manager 10.1.xlsm
    720.7 KB · Views: 2
Tech56
1)
Screenshot 2019-09-09 at 22.22.32.png


2) Do next to that cell:
Format the cell as "General". (Right-click the cell, select Format Cells, and choose "General.")
Delete the "=" at the beginning of your formula, and hit Enter. Insert the "=" back in the formula at the beginning.
 
Could you please attach the file for the correct result? I cannot seem to get this to work correctly.

Thanks
 
hello
format this cell was text ,should be as General ,and pls show this photo
 

Attachments

  • Money Manager 10.1.xlsm
    665 KB · Views: 2
  • Untitled.png
    Untitled.png
    84.7 KB · Views: 2
Tech56
Isn't this Your 'combined-file'?
For some great reason - I need to UnMark that Show Formulas after open this file!
 

Attachments

  • Money Manager 10.1 (1).xlsm
    690.7 KB · Views: 0
Back
Top