I have three large datasets on three separate tabs. I need to combine one data point from each tab inside a formula so that the formula sees these as an array. So, is there a way to create an array from cells that are not next to each other on the sheet?
I need to do this over and over about a 1000 times, hence formula better than manual.
Thank you,
Phil
I need to do this over and over about a 1000 times, hence formula better than manual.
Thank you,
Phil