There are two kinds of WPS table icons, namely "Table" and "Table (Short Stroke)".These two icons represent the same function and can be used to create and edit tables. Among them, the "table (short stroke)" icon is usually used on mobile devices, such as mobile phones and tablets.It is more concise and lightweight, suitable for use on small screens. The "Table" icon is applicable to the WPS software on the computer side.It is more detailed and professional, and can provide more functions and options. In a word, no matter which icon is used, creating and editing tables in WPS can meet the needs of users.It is easy to create beautiful and practical form works on both large and small screens.
Copy three columns A: C, and paste the values into E1. Select three columns E: G, data, and delete duplicate values. Enter or copy and paste the following formula in H2 =COUNTIFS(A:A,E2,B:B,F2,C:C,G2) Drop Down Fill
Assume as shown in the figure, select Column A to be set, and the active cell A1 The formula is'=COUNT (FIND (MID (A1, SEQUENCE (LEN (A1)), 1), ABCFJ85))=0