+ Reply to Thread
Results 1 to 4 of 4

IF Condition to date cells with concatenation of two text cells

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    11

    IF Condition to date cells with concatenation of two text cells

    Hello All,

    I'm trying to automate an excel sheet. Sheet1 contains 4 columns and n rows.
    4 Columns = A, B, C, D. Columns A and B have data(text) in them. Columns C and D have dates in them.
    D cell can be empty without a date but C wont. Now the requirement goes this way:

    If D has a date, Concatenate A and B and paste the data under Column of corresponding month(current year)
    Else
    C's date, consider it, concatenate A and B and paste the data under Column of the month(current year).

    This is the requirement. Any help appreciated.

    Regards,
    D

    A B C D
    Data with text Data With Text dd/mm/yy dd/mm/yy(this column will be empty most of the times)
    Data with text Data With Text dd/mm/yy dd/mm/yy(this column will be empty most of the times)
    ... ... dd/mm/yy

    result:
    Jan Feb Mar Apr
    Concatenated data of Cells A and B with their C/D dates falling under Jan/2013 Concatenated data of Cells A and B with their C/D dates falling under Feb/2013 Concatenated data of Cells A and B with their C/D dates falling under Mar/2013 Concatenated data of Cells A and B with their C/D dates falling under Apr/2013
    Concatenated data of Cells A and B with their C/D dates falling under Jan/2013 Concatenated data of Cells A and B with their C/D dates falling under Feb/2013 Concatenated data of Cells A and B with their C/D dates falling under Mar/2013 Concatenated data of Cells A and B with their C/D dates falling under Apr/2013
    Concatenated data of Cells A and B with their C/D dates falling under Jan/2013 Concatenated data of Cells A and B with their C/D dates falling under Feb/2013 Concatenated data of Cells A and B with their C/D dates falling under Mar/2013 Concatenated data of Cells A and B with their C/D dates falling under Apr/2013
    ....
    Last edited by desibird; 02-22-2013 at 06:12 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: IF Condition to date cells with concatenation of two text cells

    Hi Desibird

    Does the attached meet your requirements?

    Regards

    Alastair
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: IF Condition to date cells with concatenation of two text cells

    Hey Alistair, Thanks for the response. I've created a new thread in vba part of the forum and have managed to obtain the solution. Many thanks for the help.

    http://www.excelforum.com/excel-prog...48#post3135848

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: IF Condition to date cells with concatenation of two text cells

    It's good to see 2 completely different approaches tothe same issue!

    Regards

    Alastair

+ 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