The best way to set non-repeatable input in WPS type.txt

In day-to-day life and function, we frequently use the WPS form to create some data materials, some of which have particular specific qualities, including student ID, employee quantity, ID number, and so on., these information have the characteristics of non-repeatability , So we have to pay unique interest when entering manually. Is there diskgetor mp3 data recovery software to set it up in the table so that we can't enter duplicate products? Certainly there's! Here, the editor from the Word Alliance will share with you how to set the input inside the WPS kind to become non-repeatable.

① Pick the relevant cell range beneath the student quantity, click the 'Data' tab, and select the 'Validity' command.

②In the pop-up information validity dialog box, click the drop-down triangle to the appropriate of “Allow” and choose “Custom”.

③ In the dialog box under the formula, enter '=countif(A:A,A2)=1'. (A:A suggests to judge each of the cells in column A, A2 is always to judge the chosen cell, equal to 1 signifies the uniqueness in the chosen cell, the entire function expresses the which means of just about every finding out within the entire region Number is set to one of a kind).

④ Switch to the 'Error Warning' tab, click the drop-down triangle towards the ideal of 'Style', pick a process you want in the pop-up drop-down list, we pick 'Stop' and then enter 'Error' inside the dialog box under the title 'Warning', 'Error Information', enter the corresponding text, enter 'enter student number error, please re-enter', and lastly click 'OK' to finish.

⑤ At this time, only the non-duplicate products could be entered within the selected cell range. When accidentally getting into a duplicate item, an “error warning” will automatically pop up to remind.