fill in range of values with Row()

[ElmerS]

i,

Starting in cell J2 and down up to J9 - I need to preset the following values:

3
3
7
7
11
11
15
15

Tried a few times but no success.

What am I missing ?

Thanks, Elm

[Palmetto]

Please explain in more detail or post a workbook thats shows the desired rsult. It's not clear what you mean by "present data".

However, this formula in any cell will return the row number in that cell

=ROW()

[ElmerS]

Despite a small "TYPO" I still think it was clear enough.

Anyway, will the attached clear things up ?

Thanks.

[Andy Pope]

there maybe other ways but

=3+((INT(ROW()/2)-1)*4)

or

=3+(INT((ROW()-2)/2)*4)

seem to work

[ElmerS]

Works Perfect !

Thanks.