Excel avoids entering duplicate content: simple 3-step setting, duplicate data no longer exists

When making statistics on invoices, the partners in the financial department of the company usually have a column to record the invoice number, and the invoice number is unique, that is, there is no duplicate number. So when we enter the invoice number, we may accidentally enter the duplicate data, which is more troublesome to search. < / P > < p > today, I’d like to share a method to avoid entering duplicate content. After setting it up, you can rest assured that you can enter the content boldly. If the input content is repeated, the system will prompt you and save it after you modify it. < / P > < p > 1. Click the column label C, select the invoice number column, and click the button in the tab to call up the data verification window. In the data validation window, select the page, verify the condition – allow selection, and enter in the formula box: = countif & lt; 2 < / P > < p > 3. In the data validation window, select the page, check the input of invalid data to display error warning, style selection stops, input the title and error information that you need to prompt, and finally click to return to the work area. < / P > < p > 4. After the above settings, when the input invoice number is repeated, the preset error warning message will pop up, as shown in the figure below. The prompt message will not pop up until it is modified but not repeated. < / P > < p > partners, what problems have you encountered in using excel? Leave a message in the comment area to discuss and learn together. It is not easy to insist on originality. Your like forwarding is the biggest support for the editor. For more tutorials, click the column below to learn. ASMC, a lithography maker, was one of TSMC’s 14 top suppliers last year