Excel Blog
Home
Options
1,901
MS Excel Team on 12-05-2018 12:00 PM
1,245
Michael Molyneaux on 11-06-2018 02:54 PM
1,261
Steve Kraynak on 10-22-2018 11:33 AM
2,044
MS Excel Team on 10-15-2018 01:05 PM
2,796
Maha Alam on 09-27-2018 04:39 PM
28.5K
Joe McDaid on 09-25-2018 06:00 AM
18.8K
Prash Shirolkar on 09-25-2018 06:00 AM
2,641
MS Excel Team on 09-18-2018 10:06 AM
1,581
Blake T Walsh on 09-14-2018 11:54 AM
3,102
Blake T Walsh on 08-23-2018 03:30 PM
6,243
Blake T Walsh on 08-15-2018 12:11 PM
6,562
Kasper Langmann on 08-07-2018 11:41 AM
2,909
Microsoft Excel on 07-26-2018 10:50 AM
5,024
Blake T Walsh on 07-17-2018 06:15 PM
6,181
Guy Hunkin on 07-16-2018 07:29 AM
1,136
Blake T Walsh on 06-25-2018 01:23 PM
2,179
Blake T Walsh on 06-18-2018 03:43 PM
60.3K
Michael Molyneaux on 06-01-2018 08:30 AM
4,497
Johnnie Thomas on 05-10-2018 05:49 AM
1,726
Blake T Walsh on 05-08-2018 04:12 PM
1,271
Blake T Walsh on 04-23-2018 09:25 AM
4,049
Sangeeta Mudnal on 04-10-2018 11:50 AM
29.6K
John Campbell on 03-29-2018 09:00 AM
3,267
Maha Alam on 03-12-2018 05:57 PM
11.4K
Gregory Appel on 03-04-2018 04:16 AM
3,850
Guy Hunkin on 02-20-2018 08:39 AM
1,339
Blake T Walsh on 02-13-2018 04:12 PM
26.5K
Olaf Hubel on 01-23-2018 12:02 PM
6,996
Guy Hunkin on 01-18-2018 07:49 AM
1,708
Blake T Walsh on 01-17-2018 03:55 PM
Latest Comments
@Sergei Baklan I wish my mind worked in the way needed for you to have figured that out. Incredible. Thank you so much. That solution is also great for showing me some new options.
0 Likes
Any update on availability? currently on monthly targeted release and waiting patiently...… ever so patiently!
0 Likes
@GabrielMichaud, sorry, that was reply to @ChrisTank
0 Likes
I don’t have any tables, array or reference that is more than 1 cell in my example: =ACCOUNTNAME("Demo", A1) Yet Excel thinks this is an array function and suddenly/randomly changes it into a CSE array formula.
0 Likes
@GabrielMichaud, as variant that could be like if in J1:M1 is list of columns you'd like to extract in order in which you'd like to have them. The name of the source table here is "Test".
0 Likes