Dynamic column

Hi, hope you all well,

I have a column with customers with a lot duplicates.
I would like to dynamic create a new column with unique only values and excluding all customers that contains a spesific text.
f.e.

ORIGINAL COLUMN
Sakis
Sakis
Makis
Makis
Makis No

NEW DYNAMIC COLUMN
Sakis
Makis

Best Regards

Thank you very much,

I would like also to auto exclude all shells wich contains the string "No" if possible..
I want to keep only 2 cumstomer names Sakis & Makis

Thanks

Sorry, probably it is my fault but actually the string "NO" icluded on customers name like SAKISNO or MENELAOSNO) and it is not in different coulmn. So i would like to exclude those names from the new column... Thanks once more and sorry for incovinience
like :

OLD COLUMN
SAKIS
SAKIS
SAKIS NO
MENELAOS
MENELAOS NO

AND NEW COLUMN
SAKIS
MENELAOS

Thanks once more

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...).

Cell C2 formula , Drag down

Formula:

Please Login or Register  to view this content.

Thanks !!!!!!!

aeimisgr You're Welcome. Glad to help . Thank You for the feedback and rep.


If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".

hi there, I allow me to propose this another possible solution to copy and drag from C2:

Please Login or Register  to view this content.

I hope it results useful.