+ Reply to Thread
Results 1 to 9 of 9

Autofill based on data in other columns

  1. #1
    Registered User
    Join Date
    08-17-2010
    Location
    Springfield, IL
    MS-Off Ver
    Excel 2003
    Posts
    12

    Autofill based on data in other columns

    Hello... How do I explain...

    Here's my data.... two columns


    TS00005000 P
    TS00005000 S
    TS00005001 P
    TS00005001 S
    TS00005001 S
    TS00005002 P
    TS00005002 S

    I am looking for a formula that will look at both pieces of data on each row and bring in the following....

    TS00005000 P 1 OF 4
    TS00005000 S 2 OF 4
    TS00005001 P 1 OF 4
    TS00005001 S 2 OF 4
    TS00005001 S 3 OF 4
    TS00005002 P 1 OF 4
    TS00005002 S 2 OF 4

    Any ideas? Appreciate it greatly! Thanks.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Autofill based on data in other columns

    Try in C1 & copy down.

    =A1&B1&COUNTIF($A$1:A1,A1) & " "&"Of 4"
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    08-17-2010
    Location
    Springfield, IL
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Autofill based on data in other columns

    Hey. Thanks for the quick response. I didn't explain well enough. I don't want the contents of A1 and B1 in C1. I just want Excel to look at both pieces of data and input 1 of 4, 2 of 4, 3 of 4, etc. then reset back to 1 of 4 when the data changes. If you look below, Count the P's and S's. The order count differs. If there is one P, then the line should read 1 of 1. If there is one P and two S's, it should read accordingly. See below. Thanks again!

    TS00005000 P 1 of 1
    TS00005001 P 1 of 4
    TS00005001 S 2 of 4
    TS00005001 S 3 of 4
    TS00005001 S 4 of 4
    TS00005002 P 1 of 2
    TS00005002 S 2 of 2

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Autofill based on data in other columns

    You get better help, if you post an Excel file, without confidentional information.

    Please also add the desired result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Autofill based on data in other columns

    Sorry. No sense for me.

  6. #6
    Registered User
    Join Date
    08-17-2010
    Location
    Springfield, IL
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Autofill based on data in other columns

    Here ya go!
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Autofill based on data in other columns

    See the attached file.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-17-2010
    Location
    Springfield, IL
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Autofill based on data in other columns

    That will work! Thank you very much for your time.

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Autofill based on data in other columns

    glad i could help.

    thanks for the reply.

    will you mark the question as solved, if the question is solved.

+ Reply to 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