Hello,
I am back again as got fresh data for November and i tried applying both the formulae you suggested. Please see if you can help for one last time to achieve this goal.
Attaching a workbook with three Tabs,
Sheet1 (Original Sheet ),
Mod - Where below formula is applied.
IF(MOD(COLUMN(),4)=1,IF(ISERROR(MATCH(Sheet1!L2,Sheet1!$H2:Sheet1!H2,0)),Sheet1!L2,""),Sheet1!L2) & ""
Concat - Where below formula is applied.
=IF(CONCAT(--ISNUMBER(SEARCH({"phone","seen","type"},Sheet1!L$1)))="100",IF(ISERROR(MATCH(Sheet1!L2,Sheet1!$H2:Sheet1!K2,0)),IF(Sheet1!L2="","",Sheet1!L2),""),"")
My plan is to put my monthly data in Sheet1 every month and get the cleaned one from one of the sheet whichever is more efficient.
Mod - seems to be doing its work but still leaving some duplicated, you can check in the sheet there are few duplicates in few rows.
Concat - seems not working, I am sure i am doing something wrong.
Again, i can't thank you enough for whatever you already tried.