How about Excel Super contrast software?

Excel Super Contrast software is a powerful Excel file processing tool software, providing a comprehensive and effective and simple and safe work table comparison, full document comparison, grouping summary, page summary, document connection, add blank lines, Comparison filter, conditional query, condition summary nine functional modules. Use Excel Super Comparison queries to effectively help users quickly document comparisons and data aggregation, to shorten your working hours and improve your work efficiency, so that you do not have to be in the cumbersome manual contrast rollup and distress, please put the most tiring work to Excel comparison query to do it, it will be your best work assistant.

1. Comparison of any Excel worksheets (support XLS and XSLX format)

Compares the entire worksheet and allows for a variety of comparison settings (text, formulas, numeric formatting, by column comparison, by key field).

Compares any areas selected by the user on the worksheet and allows for multiple comparison settings (text, formulas, numeric formatting, comparison by column, and by key field).

2.Excel Workbook contrast

Compares all worksheets with the same name in both workbooks, and each worksheet is compared by row and column positions. and allows for a variety of comparison settings (text, formulas, numeric formats; By column comparison, by key field comparison).

3. Sub-subtotal and subtotal

You can specify multiple rollup fields, a total subtotal for the specified total field, and add to the original worksheet to distinguish them by color.