Blogs As Range References
When column references go up to XFD, you can spell things in formulas. Here are a few Excel blogs, spelled out in valid Excel 2007 formulas:
=SUM(DAI:LYD,OS:EOF,EX:CEL)
=SUM(CON:TEX,TU:RES,BL:OG)
=SUM(BA:CON,BI:TS)
=SUM(NEW:TON,EX:CEL,BA:CH)
=SUM(PT:SB,L:OG)
=SUM(S:PR,E:AD,SH:EET,P:AGE,BL:OG)
Challenge: Write a macro that accepts a text string, and creates formulas like these automatically.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.
All Topics
Filter by Category
Subscribe
Recent Comments
Other Blogs
2