Have a look at sheet Лист2, column C.
I don't have Excel 2007, so the formula in cell C3 may have to be entered using Ctrl+Shift+Enter rather than just Enter, then copied down.
For real data, the ranges may have to be extended.
Note also that the ROW()-2 part of the formula contains a 2 because the first cell is in row 3; row 3 - 2 returns 1, the SMALLest index to return. This means, whichever row your topmost formula is in, you need to replace the 2 with the row number of the formula - 1.
Not sure if IFERROR is available in Excel 2007 so the same formula without it in column B.
Anyway, if should give you some ideas.
|