Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Excel series numbers

Discussion in 'Information Technology' started by Marnie, Nov 2, 2005.

  1. Marnie

    Marnie
    Expand Collapse
    Guest

    Please help I need to give a number of records unique numbers for an import
    reference. Normally this wouldn't be a problem as I would just drag and fill
    a column with the numbers, but this time I need to go from left to right and
    then down and I can't drag and fill - does anyone know a formula that creates
    a series of unique numbers?
     
  2. Loading...

    Similar Threads Forum Date
    Canada Sukhdeep Kaur Chohan of Brampton Wins PM Award for Teaching Excellence Breaking News Mar 5, 2014
    India Sikh Regiment's Passion for Excellence Breaking News May 19, 2013
    Leisure Excellence -skills-Attitude Business, Lifestyle & Leisure Feb 14, 2010
    Katha Excellent Katha by Bhai Ram Singh Kathavachak Videos Aug 8, 2009
    [SPN] Celebrating Five Years of Excellence & Learning Announcements Jun 3, 2009

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Marnie wrote:
    > Please help I need to give a number of records unique numbers for an
    > import reference. Normally this wouldn't be a problem as I would just
    > drag and fill a column with the numbers, but this time I need to go
    > from left to right and then down and I can't drag and fill - does
    > anyone know a formula that creates a series of unique numbers?


    Are you exporting to Access?

    Sorry. This is a newsgroup dedicated to questions about Access, the
    database program in Office Professional. It appears your question may not
    be related to these subjects. The Microsoft help system is not all that
    clear and may have misdirected you here.

    It is best to ask your questions in a newsgroup dedicated to the
    subject of your question. You should find people better able to address
    your problem there.

    Note: It is always best to indicate the name and version of any
    program(s) you may be using when asking a question and also indicate the
    operating system (like Windows XP or 98) when you ask a question.


    --
    Joseph Meehan

    Dia duit
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 1 Nov 2005 08:02:02 -0800, Marnie
    <Marnie@discussions.microsoft.com> wrote:

    >Please help I need to give a number of records unique numbers for an import
    >reference. Normally this wouldn't be a problem as I would just drag and fill
    >a column with the numbers, but this time I need to go from left to right and
    >then down and I can't drag and fill - does anyone know a formula that creates
    >a series of unique numbers?


    You might want to ask this question in one of the Excel newsgroups;
    this newsgroup is for a different program, Microsoft Access.

    John W. Vinson[MVP]
     

Share This Page