Excel Blog
Home
Options
627
MS Excel Team on 10-15-2018 01:05 PM
1,542
Maha Alam on 09-27-2018 04:39 PM
9,093
Prash Shirolkar on 09-25-2018 06:00 AM
12.4K
Joe McDaid on 09-25-2018 06:00 AM
1,801
MS Excel Team on 09-18-2018 10:06 AM
1,179
Blake T Walsh on 09-14-2018 11:54 AM
2,630
Blake T Walsh on 08-23-2018 03:30 PM
3,809
Blake T Walsh on 08-15-2018 12:11 PM
5,108
Kasper Langmann on 08-07-2018 11:41 AM
2,592
Microsoft Excel on 07-26-2018 10:50 AM
4,469
Blake T Walsh on 07-17-2018 06:15 PM
5,293
Guy Hunkin on 07-16-2018 07:29 AM
1,042
Blake T Walsh on 06-25-2018 01:23 PM
1,974
Blake T Walsh on 06-18-2018 03:43 PM
58.8K
Michael Molyneaux on 06-01-2018 08:30 AM
4,009
Johnnie Thomas on 05-10-2018 05:49 AM
1,520
Blake T Walsh on 05-08-2018 04:12 PM
1,176
Blake T Walsh on 04-23-2018 09:25 AM
3,756
Sangeeta Mudnal on 04-10-2018 11:50 AM
26.1K
John Campbell on 03-29-2018 09:00 AM
3,012
Maha Alam on 03-12-2018 05:57 PM
10K
Gregory Appel on 03-04-2018 04:16 AM
3,576
Guy Hunkin on 02-20-2018 08:39 AM
1,247
Blake T Walsh on 02-13-2018 04:12 PM
21.5K
Olaf Hubel on 01-23-2018 12:02 PM
6,677
Guy Hunkin on 01-18-2018 07:49 AM
1,598
Blake T Walsh on 01-17-2018 03:55 PM
3,593
Olaf Hubel on 01-02-2018 03:16 PM
2,393
Olaf Hubel on 12-15-2017 10:35 AM
Latest Comments
Hmmm... so in New Excel, =SUM(A1:A10*B1:B10) replaces =SUMPRODUCT(A1:A10,B1:B10) Will SUMPRODUCT() and other functions that ignore implicit intersection be depreciated as existing functions start ignoring it as well - where you'd need to use SINGLE() to continue using it? (Not dropped, but where thi...
0 Likes
Does anyone know a way to find Excel files in Office 365 with CSE formulas in them? Searching for { and ={ returns nothing or in the case of Delve, errors. I'd love to see what has been done in the org over the past 2 decades and see what can be replaced with the new functions.
0 Likes
@sameer bhideThe array functions can be used in the criteria section of the Advanced Filter feature, but the new array functions will return results that dynamically expand and contract, so make sure the range in the criteria will dynamically expand as well. By default it uses absolute references.Yo...
0 Likes
Hi @Wyn Hopkins.. Thanks for the update! I will be looking forward to get this update. Super excited to explore new features! :) Regards,Mohit Verma
0 Likes
Hi @Mohit Verma, not everyone gets everything straight away in Office Insiders Fast, things are gradually released. It can be frustrating having to wait
1 Likes