Hello Ozgrid members,
Column A has some event numbers like 1500, 1700, 1760, goes on. Column B has text (a few different options) like "Home", "Business", etc.
What i'd like to have is to create a third column (Column C) includes duplicates as "Delete" but if any duplicate event number occurance (first, second, or nth) contains "Business" in Column B, either first occurance and other occurance(s) must have "Delete" word in 3rd column.
For instance, i have three 1500 (A1, A2, A3) and three 1700 (A4, A5, A6). One of the Event number 1500 has "Business" in B2. Then, C1, C2, and C3 should contain "Delete". But Event number 1700 can stay and it should contain the word "Keep" in C4, C5, C6; although it is duplicate, none of the cells in next column do not contain the word "Business".
Any help would be appreciated.