Hi,
I think that the following array formula should give a sequence of numbers in the selected range, entered with ctrl + shift + enter:
{=ROW(C4) - ROW(C$4)} (without the {}.)
However in my case: excel 2016, all values are the same: zero.
If I enter the formula with CTRL+ENTER it works, but it is not an array formula anymore.
Is this expected behavior of excel? Does anyone understand what's going on or what I am doing wrong?
Thanks,
Hombibi
Bookmarks