1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Automatically populating a summary section from multiple arrays

I'm trying to turn the green section below into a summary that will automatically populate the data from the three sections above it:

https://preview.redd.it/zgom3wubmdvg1.jpg?width=627&format=pjpg&auto=webp&s=70de6be746f934a72ec9f1011be04d2283de484b

I was able to use =index(rows(filter to include the data from the first array, but got stuck on building out the command so it would include all three. The screenshot is a sample; the actual workbook has 51 pages. Thanks!

submitted by /u/Opposite_Service6897
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com