LinkBack URL
About LinkBacks
Hi everyone,
I always remember to use Ctrl+Shift+Enter for array formulas. But I tried some array formulas today. I noticed the results are the same if I use ctrl+shift+enter or not. Do you know what happened to array formuals in Excel?
Hi everyone,
I always remember to use Ctrl+Shift+Enter for array formulas. But I tried some array formulas today. I noticed the results are the same if I use ctrl+shift+enter or not. Do you know what happened to array formuals in Excel?
Presumably, you are now using a more recent version of Excel?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi TMS, I use Office 365 now.
Both 2021 & 365 are dynamically aware & no longer need array entry.
Never know that. It looks like this is a big change for array formulas.
It si, but a lot of them can now spill so you only need the formula in one cell.Originally Posted by billj
In Office 365 it's not necessary Ctrl + Shift + Enter for array formula.
You have to use C+S+E in Excel 2019 and older. In Excel 2021 and 365 it is not necessary.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Many thanks to you all. That is really great to have it confirmed by your all Excel gulu.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks