Notifications
Clear all
Excel Tables
3
Posts
2
Users
0
Reactions
634
Views
Topic starter
I have a table array. I'd like to extract data from non-contiguous columns (e.g., column a, d, f) and put them into a spilled array on another worksheet. I'll end up doing this a few times, and then creating a stacked table from the different spilled arrays. However, I can't figure out how to create the first spilled array. I'm sure it must be a syntax issue.
I have searched the forum, but didn't see this issue.
Posted : 04/09/2025 11:52 pm
Posted : 05/09/2025 12:11 am
Topic starter
@riny That did it! I was also able to name that formula for the different stacking I needed to do and put the formula names into a vstack function to do what I was looking to do in one step. Thanks again for helping this novice out.
This post was modified 9 months ago by Kevin Kimball
Posted : 05/09/2025 10:48 pm