Hi there,
I have a spreadsheet where an array formula is stored in the top row. This formula pulls across data from another tab in relation to a unique identifier in the tab I'm working on.
However, when I try and copy the formula down to update the spreadsheet, even when I do ctrl + shft + enter it always just copies down same data as in the first row rather than looking at the data in tab it's meant to be looking in.
It's always worked in the past so I don't understand why this is happening now.
Does anyone have any ideas as to why this would happen?
Thanks,
Bookmarks