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