+ Reply to Thread
Results 1 to 4 of 4

adding the row number to a desc

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    38

    adding the row number to a desc

    Hi there

    How can I add a row number to the desc in column J.

    I thought of adding a number in a different column and then concatenate but there has to be a formula or more efficient way of doing this. Is there?

    Best Regards,
    JosvillTesting template formula_adding Line number_EMU.xlsxuploadwithLines.jpg

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: adding the row number to a desc

    Maybe use this...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-17-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: adding the row number to a desc

    i have just added to the formula concanate and it worked. Thanks PF Dave

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: adding the row number to a desc

    No problem jos, if that takes care of your thread please mark as solved, and if you're feeling generous you can add Reputation by clicking the star icon below the users name who may have helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need vba to solve select criteria get SR no after # from desc and end with result if blank
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2016, 02:42 PM
  2. Extract certain data to another workbook automatically being triggered by certain desc
    By dutchmaste in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2014, 09:12 AM
  3. Macro to unmerge and put previous cells value+Desc
    By gpcarthik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 05:37 AM
  4. Replies: 3
    Last Post: 07-17-2012, 12:18 PM
  5. Toolbar tab desc. too lengthy
    By impala096 in forum Excel General
    Replies: 0
    Last Post: 10-05-2010, 12:40 PM
  6. ENTER PRODUCT # AND HAVE assign DESC. & COST in invoice
    By notnuffun in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-15-2005, 03:10 PM
  7. insert a row if DESC and SHIFT change ...
    By vane0326 in forum Excel General
    Replies: 0
    Last Post: 02-06-2005, 11:20 AM

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