+ Reply to Thread
Results 1 to 8 of 8

Append data to repeated values with a fixed array to be repeated on value change

  1. #1
    Forum Contributor
    Join Date
    06-04-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    108

    Question Append data to repeated values with a fixed array to be repeated on value change

    Hi,,

    I am having a problem that as follows..

    In Column A having data (may be repeated/Duplicates).. and in column C had a fixed set of values..

    Column C values which are fixed, those values should be appended/show in the column B as they should start from the beginning if the value changes in column A.. look at the file I have attached with this and help me out in this regard..

    will appreciate for your highly concern..

    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: appedn data to repeated values with a fixed array to be repeated on value change

    Hi

    Can you not have a table as shown in the attached book and use Vlookup.
    =VLOOKUP(A2,$C$6:$D$11,2,0)
    Attached Files Attached Files
    --
    Regards
    Roger Govier
    Microsoft Excel MVP

  3. #3
    Forum Contributor
    Join Date
    06-04-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    108

    Re: appedn data to repeated values with a fixed array to be repeated on value change

    Quote Originally Posted by Roger Govier View Post
    Hi

    Can you not have a table as shown in the attached book and use Vlookup.
    =VLOOKUP(A2,$C$6:$D$11,2,0)
    Hello Roger,

    Thanks for the vlookup...
    but actually the workbook which i have attached is not what exactly u did.. please kindly observe the column B that the data from the fixed set how it should come..

    I hope the needful from you once again..


    Regards
    Chaitanya A

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: appedn data to repeated values with a fixed array to be repeated on value change

    i think its this way around, dont know what is required if number of items is longer than list in D tho
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Forum Contributor
    Join Date
    06-04-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    108

    Re: appedn data to repeated values with a fixed array to be repeated on value change

    Quote Originally Posted by martindwilson View Post
    i think its this way around, dont know what is required if number of items is longer than list in D tho
    Thanks for the code done...

    Still need help from you.. as if the number of duplicates exits and array values are lesser than the values exits in column A, then the array should be repeated as from the first value in the array.. I hope you understood what i need more..

    As follows
    If Coulmn A Column B Coulmn C (fixed Array)
    ABC 12 12
    ABC 20 20
    ABC 25 25
    DEF 12 30
    DEF 20
    DEF 25
    DEF 30
    DEF 12
    DEF 20


    The above "bold"DEF in column A - Column B values should repeat from the first index if the values in Fixed set is limited..

    Thanks & Regards
    Chaitanya A

  6. #6
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: appedn data to repeated values with a fixed array to be repeated on value change

    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  7. #7
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: appedn data to repeated values with a fixed array to be repeated on value change

    nope no idea what you mean!

  8. #8
    Forum Contributor
    Join Date
    06-04-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    108

    Thumbs up Re: appedn data to repeated values with a fixed array to be repeated on value change


    Thnaks for the needful

    Problem Solved...


    Quote Originally Posted by Haseeb A View Post
    Hello,

    See the attached.

+ 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