First of all, we have two WPS or Excel tables and two
selected tables All options in 2 and fill color
Then cut and paste the fill color part into table 1
Click Data - Sort - Sort by name (red marker marks the parts)
After sorting, we only need to pay attention to the color transition parts. , the same items will appear
For more related questions, you can view:FAQ
The above is the detailed content of Compare the data of two wps tables to find the same items. For more information, please follow other related articles on the PHP Chinese website!