This formula has to do with creating frequency bins (in this case, 10
bins and "Data" refers to a range):

{ = MIN(Data) + (ROW(INDIRECT("1:10"))*(MAX(Data) - MIN(Data) +1)/10) -
1}

I understand the logic of this formula, and I know that ROW-INDIRECT
portion of the formula is supposed to change (i.e. take on value
{1,2,3,...,10}) as we go down the column. However, I'm having trouble
understanding the formula beginning with ROW and ending before the
ASTERISK. Also, when I tried plugging it into excel, it always returns
the value 1 despite moving up and down the column.

Can anyone explain this to me? Thanks