Excel’s CHOOSE function with array
How to return an array of non-adjacent cells in Excel.
LINEST
CHOOSE function with LINEST in Excel
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation