Home Products Order Support Partners About Us Message Board Pass  

Two sheets compare

 

  To compare two worksheets in the same file format, generally from a different time and a different personnel edit sheet to compare. Should be canonical file format before comparison, for example removing macros and annotations, because different and contrasting text differences, this software does not support the picture contrast. First row column header should be a different name because it is worksheet than on conditions, please bear this in mind, using the other features of the software as well. Best file format is as follows:

  

1. Import File 1,import file 2, select the file 1 select area, select the file 2 select area.

2. Click on "Compare" button or menu item, the pop-up  "Compare Option" dialog box. Can select to compare content: text, formulas, numerical format. You can choose compare content, you can Multiple-select, the default compare content is the content is text. Compare mode: Compare Field, Cell Postion. Cell Postion, in strict accordance with the Row and Column of compare select area. Compare fields, you can choose a combination of conditions can choose a maximum of six fields, Click on "Compare" button to start the comparison.    

  

3. Comparative results in the bottom. Left is file 1, the order remains unchanged, the right is the file 2, if "Cell Postion" compare, sequence unchanged. If the "Compare Field "compare, the order may change. Segmentation file 1 and file 2 is a between two select area,number of file 2 is here . Compare the results with different cell background color distinction. Red: Compare the contents of different; the original document color (usually white): Compare the contents of the same; yellow: only file 1 exist; Green: only file 2 exist. Automatically opens the comparison report, you can compare the contents of the report for data matching.    

  

4. Click "Export Excel" the results can be saved and used to open Excel. Save format is XLS format, if you are Excel2007, can also save as XLSX format.

 

Two workbooks compare

 

1.       Automatic comparison of two workbooks, the contrast is "cell postion",  worksheets of the same name to compare , compared the results to form a new file.

2.       Import File 1,import file 2.

3.       click on "workbooks diff" button or menu item, a pop-up "workbook compare options" dialog box. Select comparison: text, formulas, numeric format. You can choose contrasting content, you can multi-select, comparative content is the default is text. the worksheets of the same name by comparison. Click on the "compare" button to start the comparison.    

  

4.       Comparable results in the area of the bottom, result of the comparison worksheet may have more than one, view the name of the worksheet to see the result. Left is file 1, order does not change, the right is the file 2, comparison of "cell postion", order unchanged. Compare the results with different cell background color distinction. Red: Compare the contents of different; the original document color (usually white): Compare the contents of the same; yellow: only file 1 exist; Green: only file 2 exist. Automatically opens the comparison report, you can compare the contents of the report for data matching.

  

5.       Click "Export Excel" the results can be saved and used to open Excel. Save format is XLS format, if you are Excel2007, can also save as XLSX format.

 

Group Sum

 

You select Condition of  Worksheets group sum  , the first grouping contains the second group, if you do not know why, try select group conditions, look carefully at the results.

1. Import File 1, select the file select area.

2. Click on the "Group Sum" button or menu item, the pop-up "Group Sum" dialog. Can select the grouping field can choose a maximum is six, such as the first field has five categories, then to carry out constituency grouping and 5 Subtotal, if you choose the second division, then in five categories, respectively, the second sub-grouping and subtotals, and so on, need to pay attention to is: selected records should be original, and there is no Sub-total, Total, In total, otherwise they will be double-counting. Click on the "Sum" button to start summed.

  

3. Sum of results below the results of area, different Results Subtotal cell background color distinction. First division: green; the second division: blue; the third division: yellow; fourth division: purple and so on.

  

4. Click "Export Excel" the results can be saved and used to open Excel. Save format is XLS format, if you are Excel2007, can also save as XLSX format.

 

Page Sum

 

Format to print Excel documents per page to automatically add a subtotal. Document that you print out each page has a subtotal.

1.        Import File 1, select the file select area.

2.        click the "page sum" button or menu item, a pop-up "page sum option" dialog box. Number of lines you can select the desired page, choose to display the "Subtotal" and "totals" column of the text location, location = 0, do not display text. Select the name of the field you want to summarize, can be more than  or one, is in need of attention: records of the constituency should be original, there are no subtotals, totals, Grand totals, otherwise repeat the calculation. Click on the "Sum" button to start the sum.

  

3.        the sum results in a new Excel file, you specify the number of pages added a subtotal, need to pay attention to is: in front of the page sum, you should set the print format and print header rows, determine the number of pages, number of rows should be the first page number of rows minus the header row. If the print preview is poorly formatted, should reset or reformat the print page number, page sum.

  

4.        4. Page sum the results in a new Excel file, save format XLS format, location in the folder that contains the file you want to summarize, filename = original file name +  "_ page_sum". If you are a Excel2007, you can also save as XLSX format.

 

Worksheets link

 

For two sheets have the same fields, also has different fields, in the same field to merge two tables into a single sheet.

1.       Import File 1,import file 2, select the file 1 select area, select the file 2 select area.

2.       Click on the "Sheets link" button or menu item, the pop-up "Sheets link option" dialog box. Can choose the link of the field can choose a maximum of six, File 1 row and file 2 row conditions link. Click on "link" button to start the merger.

  

3.       Link results in the bottom. Left is file 1, the order remains unchanged, the right is the file 2,  the order may change. Segmentation file 1 and file 2 is a between two select area,number of file 2 is here . Compare the results with different cell background color distinction. Red: Compare the contents of different; the original document color (usually white): Compare the contents of the same; yellow: only file 1 exist; Green: only file 2 exist.

  

4.       Click "Export Excel" the results can be saved and used to open Excel. Save format is XLS format, if you are Excel2007, can also save as XLSX format.

 

Add Blank Row

 

To add several blank lines over a sheet.

1.       Import File 1, select the file select area.

2.       Click on the "Add Blank Row"  button or menu item, the pop-up "Add Blank Row" dialog box. Can choose the number of blank rows, click the "add" button to start to add blank rows.

  

3.       To add the results of blank rows at the bottom of the results area.

  

4.       Click "Export to Excel" the results can be saved and used to open Excel. Save format XLS format, if you are Excel2007, can also save as XLSX format.

 

Contrast query

 

Same conditions respectively to two tables to filter the records easier to comparison count.

1 Import File 1,import file 2, select the file 1 select area, select the file 2 select area.

2 Click "compare query" button or menu item, a pop-up "Select option" dialog box. You can select the filter criteria there were six, selection criteria name, enter the criteria values, you can select more than one condition, condition is between and. Click on the "filter" button to start the filter

  

    

3 The results at the bottom of the results area.

  

4 Click "Export to Excel" the results can be saved and used to open Excel. Save format XLS format, if you are Excel2007, can also save as XLSX format.

 

Advance conditions query

 

Multiple query condition combination on the worksheet, query records that meet the conditions.

1.       Import File 1, select the file select area.

2.       click the "more query" button or menu item, a pop-up "select conditions" dialog box. According to the first row of the Excel file name fields, build the query condition, can be any combination of conditions, conditions are "and"  the relationship between, as long as you are correct, you can query a result, combinations of conditions are gradually learning. Click on the "query" button to start the query.

  

3.       The results at the bottom of the results area.

  

4.        Click "Export to Excel" the results can be saved and used to open Excel. Save format XLS format, if you are Excel2007, can also save as XLSX format.

 

Advance conditions sum

 

Multiple query terms to the worksheet, grouped summary criteria combination query, query records that meet the conditions.

1.       Import File 1, select the file select area

2.       click the "more sum" button or menu item, a pop-up "select conditions" dialog box.

     (1) according to the first row of the Excel file name fields, build the query condition, can be any combination of criteria, you can select more than one condition, condition is between "and".

     (2) here needs select grouped conditions, can select of Grouped field up can selected six a, grouped is on line records for group, grouped can embedded set, as first group has five category and subtotal, if select has second group, then is in five groups in respectively for second group and subtotal, and so on,

     (3) Finally, select the numeric columns that digitally added, click on the "Sum" button to start the sum.

  

5.       The results at the bottom of the results area.

  

3.        Click "Export to Excel" the results can be saved and used to open Excel. Save format XLS format, if you are Excel2007, can also save as XLSX format.

 

Home   |   Products   |   Order   |   Support   |   Partners   |   About Us

Copyright(C)2008 Three-soft. All rights reserved.