Welcome to the March 2023 update. This month, we are excited to announce several new features across web, Windows, and Mac. For web users, speed up large workbooks with Check Performance, insert and ...
Updated Mar 28, 2023
Version 1.0
Blog Post
I prefer to have Excel Cell Function on Excel Web; as-is, I have to switch to Desktop Edit but when blocked in public computers, do I carry a Windows Laptop (with Tablet, Smartphone for our digital AND also work-anywhere environment)? just to use Excel Desktop?
Sheet name function reduce creation of next Helper Sheet(s) if it indirectly reference Sheets that start with same name.
INDIRECT(TEXTAFTER(CELL("filename",A1),"]").....)
This is my stopgap measure of using functions that work across rows only like MMULT but Date are in columns.
I am adding a sheet
Sheet_Local_Currency_Months-In-Columns
Sheet_Local_Currency_Months-In-Columns_Transposed
Without Sheet Name function, I need to hand transpose every Sheet.