- Average user rating: 0 stars Not yet available
Back to product review - My rating: 0 stars Write review
Full user review
-
5 stars
Version: Compare Sheets 1.1.1
"How to use Compare Sheet"
Pros: How to use Compare Sheet read bellow
Cons: How to use Compare Sheet read bellow
Summary: Hi
I am author of Compare Sheet. Reading above comments I see people does not know how to use Compare Sheets free program, so I decided to give more details on how to use it.
1. You need to prepare data before to pass it to Compare Sheet
-create new .xls file
-in sheet1 and sheet2 paste data you want to compare keeping column header rows. Check TestBook.xls file to see how data in sheet1 and sheet2 must looks like.
-save file and exit excel
2. Open prepared file in Compare Sheet. Data in sheet1 is loaded and displayed as table1 and data in sheet2 is loaded and displayed as table2
3. Select reference field by selecting column name for table1 and table2
4. Select criteria to be used for comparing tables(sheets)
5. Type name of result sheet or check auto check box
6. If you want result to be placed in new file fill result file field. If you leave result file field empty result will be placed in source file in sheet named according to your entry in step 5
7. Click on compare button to compare tables/sheets
Note:
- data in column you use to compare tables must be homogeneous ( of same type - all numbers or all text, but not both).
- reference filed columns of both tables must be of same data type - both numbers or both text
- it is recommended to convert columns containing formulas to text before to compare data
Submit your review
You must be 13 years of age or older to submit personal information to CNET Networks. In compliance with the Children's Online Privacy Protection Act of 1998, CNET Networks does not accept name and e-mail address information from users who are under 13 years of age.
All submitted ratings and written comments become the sole property of CNET Networks, Inc. (CNET) and may be used at CNET Networks' sole discretion. Ratings and written comments are generally posted within two to four business days in batch groups, not in real time. However, CNET Networks reserves the right to remove or refuse to post any submission for any reason. You acknowledge that you, not CNET Networks, are responsible for the contents of your submission.
CNET Networks is not responsible for the content of the publisher's descriptions or user reviews on this site. We encourage you to determine whether this product or your intended use is legal. We do not encourage or condone the use of any software in violation of applicable laws. CNET Download.com does not sell, resell, or license any of the products listed on the site. We cannot be held liable for issues that arise from the download or use of these products.
