Excel Blog
Home
Options
911
Theresa Estrada on 01-25-2019 02:18 PM
2,580
MS Excel Team on 12-05-2018 12:00 PM
1,615
Michael Molyneaux on 11-06-2018 02:54 PM
4,613
Steve Kraynak on 10-22-2018 11:33 AM
2,340
MS Excel Team on 10-15-2018 01:05 PM
3,365
Maha Alam on 09-27-2018 04:39 PM
23.2K
Prash Shirolkar on 09-25-2018 06:00 AM
44.7K
Joe McDaid on 09-25-2018 06:00 AM
3,331
MS Excel Team on 09-18-2018 10:06 AM
2,053
Blake T Walsh on 09-14-2018 11:54 AM
3,592
Blake T Walsh on 08-23-2018 03:30 PM
8,761
Blake T Walsh on 08-15-2018 12:11 PM
7,649
Kasper Langmann on 08-07-2018 11:41 AM
3,032
Microsoft Excel on 07-26-2018 10:50 AM
5,755
Blake T Walsh on 07-17-2018 06:15 PM
6,790
Guy Hunkin on 07-16-2018 07:29 AM
1,234
Blake T Walsh on 06-25-2018 01:23 PM
2,352
Blake T Walsh on 06-18-2018 03:43 PM
61.8K
Michael Molyneaux on 06-01-2018 08:30 AM
4,956
Johnnie Thomas on 05-10-2018 05:49 AM
1,889
Blake T Walsh on 05-08-2018 04:12 PM
1,350
Blake T Walsh on 04-23-2018 09:25 AM
4,445
Sangeeta Mudnal on 04-10-2018 11:50 AM
32.3K
John Campbell on 03-29-2018 09:00 AM
3,508
Maha Alam on 03-12-2018 05:57 PM
13K
Gregory Appel on 03-04-2018 04:16 AM
4,051
Guy Hunkin on 02-20-2018 08:39 AM
1,428
Blake T Walsh on 02-13-2018 04:12 PM
31.9K
Olaf Hubel on 01-23-2018 12:02 PM
7,240
Guy Hunkin on 01-18-2018 07:49 AM
Latest Comments
@Joe McDaid - any progress on the updates? Excited to test it. And did you get my file that SINGLE() was corrupting formulas so non-Dynamic Array aware versions got errors instead of CSE style functions?
0 Likes
Hi @Steve Kraynak, Thanks for Sharing This Useful Information. It is a good idea to Create a Custom Keyboard Shortcut.
0 Likes
Further to Ed Hansberry's last post, it seems to me that the basic problem is that the dynamic arrays either return the full array, or they return the "spill" message. That may be OK for some applications, but for many it makes them unusable, with the only workaround being to enter the array as a fi...
0 Likes
Thanks @Joe McDaid. I think the confusion, at least on my part is why does this happen?Create formula =INDEX(tblCalendar[Years],Settings!C1) in Insider build. Stays like that. It works without SINGLE()Create formula =INDEX(tblCalendar[Years],Settings!C1) in other build, it works in non-insider build...
1 Likes
@GabrielMichaud This is expected as UDF's have the ability to return ranges/arrays and trigger implicit intersection. That said, we will be announcing some improvements to the experience in the next few days - so watch this space.
1 Likes