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.