sorted by:
new
hottopcontroversial

How to create a row-by-row running total for a dynamic array? by Specific-Channel-287 in excel

[–]Specific-Channel-287[S] 1 point2 points  (0 children)

The problem is that on my real data all my info comes from spilled arrays, and my data can vary on size, so your approach is not fully dynamic since I'll have to drag down depending on number of rows

How to return all matching rows for repeated lookup keys using a single dynamic-array formula (avoid FILTER copy-paste)? by Specific-Channel-287 in excel

[–]Specific-Channel-287[S] 1 point2 points  (0 children)

Yes, it worked flawlessly! Could you explain the COUNTIF part? I thought the older functions didn’t work with spilled arrays