Blog Post

Excel Blog
3 MIN READ

Preview of Dynamic Arrays in Excel

JoeMcDaid's avatar
JoeMcDaid
Icon for Microsoft rankMicrosoft
Sep 25, 2018
July 1st 2020 Update Dynamic Arrays is now available to Office 365 users on all endpoints.    Until now, you wrote a formula for each value you wanted returned to the grid. One formula, one val...
Updated Oct 05, 2020
Version 11.0
excel
KanwalNo1's avatar
KanwalNo1
Iron Contributor
May 09, 2020

JoeMcDaid HennSarv lori_m @Sergei Baklan

Is there any way to mix Dynamic Array Functions with normal extendable functions.

I am using the following function to filter some data from the database, which is working fine. I tried to make it work with normal functions so that I don't have to manually fill the formula to match the increased number of rows, as and when more data is added to the database and that gets filtered in the report. Formula entered in Cell U6, U7 and U8 is same as I am using Dynamic Array Functions. So Amount of 100, 200 and 300 is not being deducted as intended. U6 is Ok, but U7 should be 32200 instead of 32300 and U8 should be 950 instead of 1150.

 

=ROUND(FILTER(Main6DB12EFrt,IFNA(XMATCH(Main6DB06Inco,{"EXW1","EXW2"}),0)," ")-$R6-$T6,0) 

 

 

I ask such queries here, as it seems Best platform to discuss issue related to Dynamic Array Functions.

Kanwaljit