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
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
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.
Bookmarks