Closed Thread
Results 1 to 4 of 4

row number in a formula in Excel?

  1. #1
    NordicElf
    Guest

    row number in a formula in Excel?

    How do I use a row number in a formula calculation in excel?
    For .e.g I want to have cell = 3/(current row number).

    Also is it possible to make row numbers start from 0?

  2. #2
    JE McGimpsey
    Guest

    Re: row number in a formula in Excel?

    One way:

    =3/ROW()

    In article <DB241477-24D8-4C64-9179-27B01F79A0C7@microsoft.com>,
    NordicElf <NordicElf@discussions.microsoft.com> wrote:

    > How do I use a row number in a formula calculation in excel?
    > For .e.g I want to have cell = 3/(current row number).
    >
    > Also is it possible to make row numbers start from 0?


  3. #3
    Niek Otten
    Guest

    Re: row number in a formula in Excel?

    =3/ROW()

    First row is row 1. Of course you can use =3/(ROW()-1)

    --

    Kind Regards,

    Niek Otten

    Microsoft MVP - Excel

    "NordicElf" <NordicElf@discussions.microsoft.com> wrote in message
    news:DB241477-24D8-4C64-9179-27B01F79A0C7@microsoft.com...
    > How do I use a row number in a formula calculation in excel?
    > For .e.g I want to have cell = 3/(current row number).
    >
    > Also is it possible to make row numbers start from 0?




  4. #4
    Registered User
    Join Date
    02-01-2012
    Location
    Seattle
    MS-Off Ver
    Excel 2010
    Posts
    2

    please moderator delete this post

    this was meant for a different thread
    Last edited by Videogamer555; 02-01-2012 at 01:36 AM. Reason: message in wrong thread, please delete post

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1