Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Control the Number of Times the Same Content Is Entered in an Excel Cell?

Date:2021-1-29 Author:Sandra

Maybe you haven’t met this kind of situation before, but Skill is no burden, the author will introduce this in detail. come and start to learn!

Step1:

Open an Excel book and take Price as an example.

How to Control the Number of Times the Same Content Is Entered in an Excel Cell?

Step2:

Select the cells and go to Data Validation in toolbar.

How to Control the Number of Times the Same Content Is Entered in an Excel Cell?

Click Settings window and choose Custom in the list, and enter

=COUNTIF($D$3:$D$12,D3)<4 in the Formula box.

How to Control the Number of Times the Same Content Is Entered in an Excel Cell?
How to Control the Number of Times the Same Content Is Entered in an Excel Cell?

Step3:

Click the Error Alert window and fill in the content of the Title and Error message, then click OK.

How to Control the Number of Times the Same Content Is Entered in an Excel Cell?
How to Control the Number of Times the Same Content Is Entered in an Excel Cell?
How to Control the Number of Times the Same Content Is Entered in an Excel Cell?

Now, you are not allowed to enter the same content more than three times, if you still try to, there will be a alert box to stop you.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *