- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
Features of Xiaodong Excel Two Sheet Comparison Assistant
No need to specify complex formats, any format can be directly compared
Select the file and the data will be automatically read into the software
Comparative items do not need to be sorted, do not need to be on the same row, and do not need to be on the same column
You can freely set the area of the table to participate in comparison
Supports simultaneous comparison of multiple sets of data and free switching of multiple sheets
The comparison result will show the different parts of the two tables, the same parts of the two tables, table A has the table B table does not have, B table has the table A table has not, the main column is not unique
New single table processing function section: deduplication based on main columns, complete duplication, conditional averaging, conditional summation, etc.
New single -column processing function sector: support single -column data check, statistical statistics appear data, etc.
Comparison results of junior version and above can be exported
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
Xiaodong Excel two-sheet comparison assistant update log
1.Fix several bugs;
2. Optimize detailed issues;
Huajun editor recommends:
Xiaodong Excel two-sheet comparison assistant software feels really good! The editor specially tested it for this purpose, and it works really well.Today's goal,Hanwang Attendance Management System,Aimo mind map,WPS Office,NTKO large file upload controlThese are all very good software tested by the editor, come and choose the one that suits you!
Your comment needs to be reviewed before it can be displayed