Excel Blog
Home
Options
917
Theresa Estrada on 01-25-2019 02:18 PM
2,588
MS Excel Team on 12-05-2018 12:00 PM
1,620
Michael Molyneaux on 11-06-2018 02:54 PM
4,635
Steve Kraynak on 10-22-2018 11:33 AM
2,341
MS Excel Team on 10-15-2018 01:05 PM
3,369
Maha Alam on 09-27-2018 04:39 PM
23.2K
Prash Shirolkar on 09-25-2018 06:00 AM
44.8K
Joe McDaid on 09-25-2018 06:00 AM
3,334
MS Excel Team on 09-18-2018 10:06 AM
2,056
Blake T Walsh on 09-14-2018 11:54 AM
3,597
Blake T Walsh on 08-23-2018 03:30 PM
8,781
Blake T Walsh on 08-15-2018 12:11 PM
7,658
Kasper Langmann on 08-07-2018 11:41 AM
3,035
Microsoft Excel on 07-26-2018 10:50 AM
5,762
Blake T Walsh on 07-17-2018 06:15 PM
6,795
Guy Hunkin on 07-16-2018 07:29 AM
1,236
Blake T Walsh on 06-25-2018 01:23 PM
2,355
Blake T Walsh on 06-18-2018 03:43 PM
61.8K
Michael Molyneaux on 06-01-2018 08:30 AM
4,970
Johnnie Thomas on 05-10-2018 05:49 AM
1,891
Blake T Walsh on 05-08-2018 04:12 PM
1,353
Blake T Walsh on 04-23-2018 09:25 AM
4,449
Sangeeta Mudnal on 04-10-2018 11:50 AM
32.3K
John Campbell on 03-29-2018 09:00 AM
3,509
Maha Alam on 03-12-2018 05:57 PM
13K
Gregory Appel on 03-04-2018 04:16 AM
4,055
Guy Hunkin on 02-20-2018 08:39 AM
1,431
Blake T Walsh on 02-13-2018 04:12 PM
32K
Olaf Hubel on 01-23-2018 12:02 PM
7,244
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