+ Reply to Thread
Results 1 to 12 of 12

Help with concatenation/combining cells...

  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    Arlington, WA
    MS-Off Ver
    Excel 2013
    Posts
    40

    Help with concatenation/combining cells...

    Not sure if a concatenation or some other formula is neccessary.
    Here is what I have:

    On 'sheet1'
    Column A (A3:A2000) has employee numbers
    Column B (B3:B2000) has dates
    Column C (C3:C3000) has different codes - this is just text

    On 'sheet2'
    Row 2 - Cells E2:K2 have dates in them
    Column C (C3:C3000) has employee numbers
    Column L (L3:L3000)- this is where I need to return the information.

    Basically, I'd like to return all of the codes from sheet1 based on the dates only from cells E2:K2 and the employee number on sheet1 and sheet2 (need to match those). I'd like to somehow concatenate all of the codes into the cells in column L, which would only be text.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,891

    Re: Help with concatenation/combining cells...

    you could add a helper column between B and C sheet1 to combine B & A (=B&A), and then on sheet 2m you could use vlook to find the references in E2-K2&C3-C3000??? with =vlookup(e$2&$C3,Sheet1!C:D,2,false)

    let me know how that works for you?
    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

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,081

    Re: Help with concatenation/combining cells...

    Pl see attached file.
    If you are satisfied Mark the thread solved.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-19-2010
    Location
    Arlington, WA
    MS-Off Ver
    Excel 2013
    Posts
    40

    Re: Help with concatenation/combining cells...

    New Off Call time tracker2.xlsmNo, that doesn't work. I'll upload my document. What I need is for the cells in column L of "VI Weekly Info" to concatenate the codes found in column C of "Rolling OC Log" based on the dates found in row 2 of "VI Weekly Info" as well as to match the VRS# found in column C in "VI Weekly Info" to the VRS# found in column A of "rolling OC log".

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,891

    Re: Help with concatenation/combining cells...

    i cant seem to understand what you expect the answer to, sorry. could you give few example answers please, and explain how you arrived at the answers?

  6. #6
    Registered User
    Join Date
    10-19-2010
    Location
    Arlington, WA
    MS-Off Ver
    Excel 2013
    Posts
    40

    Re: Help with concatenation/combining cells...

    The way that it is set up right now with the information in it, cell L4 would return the following: "LMS Training, POC Duties" since it would concatenating the text from column C on 'RollingOCLog' based on the specified date range and VRS#.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,891

    Re: Help with concatenation/combining cells...

    does that mean that "LMS traing" comes from Rolling OC Log C16 and "POC Duties" comes from Rolling OC Log C17, because they are both Terp# no 3002 and fell om 8/12/12?

  8. #8
    Registered User
    Join Date
    10-19-2010
    Location
    Arlington, WA
    MS-Off Ver
    Excel 2013
    Posts
    40

    Re: Help with concatenation/combining cells...

    Correct. And, as long as that particular person had anything in Column C of 'RollingOCLog' during the date range of 8/12-8/18 (as specified in row 2 of 'VI Weekly Info') I would want it returned in column L, concatenated.

  9. #9
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help with concatenation/combining cells...

    If you post a sample file of your own showing a good example of the data and manually mocked up "results" on your second sheet, I'll see about installing a custom function that will do the string concatenation for you. NOTE: the addition of a custom function would change the workbook type to .xlsm.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  10. #10
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,081

    Re: Help with concatenation/combining cells...

    Pl see attached file with Macro "GetFromRollingSheet".
    Attached Files Attached Files

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,891

    Re: Help with concatenation/combining cells...

    Thx for the assist JB

  12. #12
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help with concatenation/combining cells...

    Haven't done anything yet....

+ 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