{=table(,k1)}

[gavs73]

Hi, would appreciate any help, I'm trying to unpick someone else's spreadsheet, and there is an Array formula {=TABLE(,K1)} with K1 being a date.

Magically numbers have appeared in the array, but I've no idea where from when all it is pointing at is a date.

Is there any way to reverse engineer this ?, presume it's an Array formula, but it must be looking at something in the first place, is there any way to see what ?

Thanks in advance

Gav

 

[RoryA]

It's a one parameter data table. Check the cell above the first cell with a TABLE formula in it. It should either have a formula in it, or point to a cell that does. K1 in the formula is the input cell that is substituted with the values to the left of the TABLE formulas. Simple example of setting one of these up is given here: https://www.dummies.com/software/mi...eate-a-one-variable-data-table-in-excel-2010/