Hi all,
I'd like to get your support to solve this issue with given conditions below (column C = what I'd like to get). Thank you in advance.
1. If data in column B not found in column A => C = A
(example B1 = "ee" not found in column A1 = "dd" => C = "dd")
2. If data in column B found in column A => delete letter that found in column A
(example B2 = "ee" & found in column A2 = "dd, ee, ff" => C = dd, ff)
I'd like to get your support to solve this issue with given conditions below (column C = what I'd like to get). Thank you in advance.
1. If data in column B not found in column A => C = A
(example B1 = "ee" not found in column A1 = "dd" => C = "dd")
2. If data in column B found in column A => delete letter that found in column A
(example B2 = "ee" & found in column A2 = "dd, ee, ff" => C = dd, ff)