none
Fill handle adding 14 decimal places when multiple numbers RRS feed

  • Question

  • I need to count like this:

    1

    1

    2

    2

    3

    3

    Down about 6,000 rows.

    When I use the Fill handle, I get

    1

    1

    2

    2

    3

    3

    3.6

    4.057142857

    4.514285714

    4.971428571

    etc 

    instead of 

    1

    1

    2

    2

    3

    3

    4

    4

    5

    5

    etc

    I've tried formatting the cells in all kinds of ways, including no decimal.  I've tried lots of things.

    Does anyone have any ideas?

    Thank you in advance.


    Gee

    Tuesday, November 28, 2017 9:02 PM

Answers

  • Mr. Excel answered my question:

    INT((ROW()-ROW($A$1))/2)+1


    Gee

    • Marked as answer by GretaF Tuesday, November 28, 2017 9:23 PM
    Tuesday, November 28, 2017 9:23 PM