Xiaodong Excel two-sheet comparison assistant

Xiaodong Excel two-sheet comparison assistant function list

​ ​ 1. Comparison direction of the two tables:

​ ​ 1. Single main column comparison (a certain column of table A compared to a certain column of table B)

​ ​ 2.Multiple main column comparison (supports up to six groups)

​​ 3.Multiple comparison columns (you can set multiple sets of comparison ratios, unlimited sets)

​​ 4. To compare historical records, you can click to select recent comparison records and enter the comparison box directly.

5. Advanced rules for comparison columns: (limited to mid-to-high-level versions)

5.1. If the amount is less than 0.5, it will be calculated as 0.5.

5.2. If the amount is less than 1.0, it will be calculated as 1.0

5.3. Ignore the decimal point and round to the nearest whole

5.4. Rounding after the decimal point

6. Comparison results:

​​ 6.1. The two tables are different

​ ​ 6.1.1 Find the difference value of the comparison column

​ ​ 6.1.2 Find the maximum value of the comparison column

​ ​ 6.1.3 Corresponding data in Appendix A

​ ​ 6.1.4 Corresponding data in Appendix B

​ ​ 6.1.5 Find the extra characters in the comparison value (according to split characters, limited to mid-to-high-end versions)

​ ​ 6.1.6 Display the similarity ratio of comparison columns (limited to mid-to-high-level versions)

​​ 6.2 The two tables are the same

​​ 6.2.1 Corresponding data in Appendix A

​ ​ 6.2.2 Corresponding data in Appendix B

​ 6.3 Table A is present and table B is not present

​ 6.4 Table B has table A but does not

​ ​ 6.5 The main column is not unique (which includes finding the difference according to the occurrence of secondary data in the main column, removing completely duplicate rows, summing and comparing columns based on the main column)

​ ​ 6.5.1 Find the difference based on the occurrence of secondary data in the main column

​​ 6.5.2 Remove exact duplicate rows

​​ 6.5.3 Sum and compare columns based on the main column

7. Fetching numbers across tables and displaying in large tables

​​ 7.1 Get the corresponding data from another table based on the comparison results (limited to medium and high versions)

7.2 Coloring based on comparison results (coloring various results at once)

​ 8. Small table coloring: separate coloring according to different comparison results

9. The two tables are the same. If the two tables are different, you can attach the data of the other table according to the corresponding relationship.

​ ​ 10.excle export: All comparison results except the trial version support export

​ ​ 2. Single column analysis section

​​ 1. Count the number of occurrences of a single column

​ ​ 2. Query single column repeated data

3. Extract the uniqueness of a single column

​​ 4. Data splitting: split according to conditions, can be displayed horizontally and vertically (limited to mid-to-high-level version users)

​​ 5.excle export: All comparison results except the trial version support export

3. Multi-column comparison: You can find similarities and differences in multiple columns in a table

​ ​ 4. Single table data processing

1. Count the number of occurrences based on the main column

​​ 2. Calculate the specified column based on the main column grouping

2.1 Group summation

​ ​ 2.2 Group average

​ ​ 2.3 Grouping to find the maximum value

​ ​ 2.4 Find the minimum value by grouping (limited to mid-to-high-level version users)

​​ 3.Group display according to main column

​​ 4. Remove duplicate rows based on the main column

5.Remove exact duplicate rows

​ ​ 6. Export to Excel