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
Bookmarks