+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Autofill based on column data

Hybrid View

  1. 06-27-2012, 05:10 PM #1
    db3712
    db3712 is offline
    Registered User
    Join Date
    08-17-2010
    Location
    Springfield, IL
    MS-Off Ver
    Excel 2003
    Posts
    12

    Autofill based on column data

    Hey,
    I have a data set (column 1) in my spreadsheet. I need to concatenate sequentially an @@1, @@2 and @@3 to the end of the first three entries as seen in column 2. Once the data changes to the next set of numbers (SV1206256002), I need to start the sequence of @@1, @@2 and @@3 over again. Is there a way to do this with autofill \ concatenate or perhaps another way without having to do this manually? Thank you...


    SV1206256001 SV1206256001@@1
    SV1206256001 SV1206256001@@2
    SV1206256001 SV1206256001@@3
    SV1206256002 SV1206256002@@1
    SV1206256002 SV1206256002@@2
    SV1206256002 SV1206256002@@3
    SV1206256003
    SV1206256003
    SV1206256003
    Reply With QuoteRegister To Reply
  2. 06-27-2012, 05:48 PM #2
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Autofill based on column data

    db3712,

    Welcome to the forum!
    In cell B1 and copied down:
    =A1&"@@"&COUNTIF($A$1:A1,A1)
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 06-27-2012, 06:23 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Autofill based on column data

    =A1&"@@"&row(A1) copied down will also work, if you want an alternative
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 06-27-2012, 06:31 PM #4
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Autofill based on column data

    FDibbins, I don't see how that would reset the count when a new item is encountered in column A. Wouldn't the result just be...
    SV1206256001 SV1206256001@@1
    SV1206256001 SV1206256001@@2
    SV1206256001 SV1206256001@@3
    SV1206256002 SV1206256002@@4
    SV1206256002 SV1206256002@@5
    SV1206256002 SV1206256002@@6
    Reply With QuoteRegister To Reply
  5. 06-27-2012, 08:07 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Autofill based on column data

    oops yes, i stand corrected, thanks TA, i wasnt thinking of the base number changing
    Reply With QuoteRegister To Reply
  6. 06-28-2012, 10:06 AM #6
    db3712
    db3712 is offline
    Registered User
    Join Date
    08-17-2010
    Location
    Springfield, IL
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Autofill based on column data

    Thank you both. I appreciate it. Works perfectly.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1