• Home
• Services
• Knowledge Base
• Analysis Services - SSAS
• Excel
• Useful Tricks
• Index and Match
• Members Area
• Contact Us
Username

Password

Excel

Useful Tricks

Dynamically display the tab name on the worksheet.

 

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

 

 

•    
• 
• © Copyright 2008 mdw.com.au