Win7 uses WPS to make a list form to prevent repeated input methods

  

Win7 uses WPS to make a list table to prevent repeated input methods

1. Select the cell column that needs to prevent duplicates in the list, and then click [Data] & mdash in the menu bar; [Validity] ;

2, in the "Settings" tab, select "ldquo" from the drop-down menu, and then enter: countif($E$2:E2,E2 in the "Formula" )=1 (the specific value depends on the region) Click to confirm the save settings;

3. After the setup is completed, we will enter the same name and an error message will appear!

Copyright © Windows knowledge All Rights Reserved