Prevent Duplicate Entries in Excel - Tutorial

Thank you❤

Thank you.

Thankyou so mcuh. Means a lot to me.

That genius trick

Tried many different videos and formulas but none worked, but your method worked first time! Thank you

I need to prevent the duplicate entries alongside with character limit. How can I do this?

Thank you

Only problem; this only works if you try to actually type in the value; unfortunately, this does not prevent copy-pasting the same data repeatedly 😑

Good video. Easy to follow.

Really understand able and use fully

The =1 at the end of the formula is error. my excel wont accept it.

Omg, I love your videos, I was looking for a way so I wouldn't duplicate names, here at work, and this is the answer to my problem, which you made look so simple.Thank you so much, you teach excel so wonderfully!!! I subbed to learn more!! 👍

Good video. To the point and it works.