+ Reply to Thread
Results 1 to 2 of 2

Enter text in column a based on data in several other columns for groups of rows

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Enter text in column a based on data in several other columns for groups of rows

    Hello,

    I'm looking to enter in column A of the attached spreadsheet either "AddProduct" or "AddProductVariant".

    example-data-action.xlsx

    Rule one is if there is nothing in H2 then enter "AddProduct" in A2 - this is no problem.

    Second rule is for each group of matching Variant Titles in column C where the variant option (in this case colour, battery, option though there could be more or less) is duplicated then make the first row entry in colum A for the first duplicate entry "AddProduct" and the rest for the group "AddProductVariant".

    Or the second rule could work by, of the group of matching Variant Titles in column C where Variant Default is "yes" enter in column A for the first one of the two "AddProduct" and for the restof the rows in that group "AddProductVariant".

    I hope this is possible and I will be greatful for any help you can offer with this.

    Thanks in advance and best regards,

    Paul
    Last edited by mrswain; 11-27-2012 at 12:20 PM.

  2. #2
    Registered User
    Join Date
    08-07-2012
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Enter text in column a based on data in several other columns for groups of rows

    Sorry if I was not clear on what I needed.

    I have attached an example of what I am trying to achieve on sheet 2 of the spreadsheet.

    example-data-action.xlsx

+ 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