Additional Columns Autofill In Excel

Hi, I’m looking to help with a workflow for my transactions sheet in Excel. I like to add additional columns to the right to help get better data (not sure if that’s a good practice). My issue is that when new data comes in to the feed it pushes my formulas down, thus eliminating my index/matches from those columns.

I know in google sheets you can use =arrayformula to get it to autofill when you bring something new in but what is the fix for that in Excel?

Any help would be appreciated.

Hi @shelbygrosch,

I don’t have any concrete examples and I don’t think there is a comparative solution in Excel, but here’s a resource someone on the team found