Array enter ANY formula in A1, say =0 (ctrl/shift/enter)
then select A1:B2, merge cells.
Now re-enter the array-formula in A1.
You get a strange message: "Array formulas are not valid in Merged Cells".
Well it was fine before I RE-entered it!
Okay, that's bizarre. Could be useful for someone who actually merges cells though...
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Posting Permissions
Reply With Quote
Bookmarks