Compare Sheets User Reviews
0 stars Not yet available
Results 1-3 of 3
-
"Compares 2 sheets as long as you have them setup right"
Version: Compare Sheets 1.1.1
Pros
Takes a process that used to take 1-2 hours and completes it in mere seconds
Allows changing processes now that we can use this utilityCons
You have to be cautious and make sure that you have all the parts right before trying to use it - after that it's smooth sailing
Summary
Love love love it!!!! I can compare hundreds of lines of data in a couple of seconds and tailor the results I want.
If you are using Excel 2007 or newer YOU MUST SAVE THE EXCEL SHEET IN VERSION 97-2003 for this to work!!!
Updated on Apr 19, 2011
Once I figured that out it was business as usual!! -
"How to use Compare Sheet"
Version: Compare Sheets 1.1.1
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 -
"Doesn't work"
Version: Compare Sheets 1.1.1
Pros
Easy to install.
It managed to open the first file just fine.
Cons
There is no box to select a second file to compare to (or if there is, it's hiding). Whenever I click "Compare" regardless of how many files I've selected, I get an error message.
Add Your Review
Submit your reply
E-mail this review
Report offensive content
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.
