The Safe Free Download SiteWhy not become a full member?, it's fast, free and allows you to participate in our forums and add or comment on our free software, leave reviews, access unlimited free downloads and more! - we NEVER share your details with anyone else, that's a promise! ... REGISTER FREE TODAY |
READ / WRITE REVIEWS File Information
- Submitted: Sep 14 2009 10:00 PM
- Last Updated: Sep 14 2009 10:00 PM
- File Size: 349.76K
- Views: 771
- Downloads: 28
- Will Run On: 9x/ME/NT/2K/XP/2K3/Vista/7
- Author's Site: Click Here
Compare Sheets 1.1.1
Download Now
Compare two tables created with MS Excel and create result table containing rows from first table that have or haven`t equivalent in second table according to given criteria.
To use Compare Sheets
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
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
Select reference field by selecting column name for table1 and table2
Select criteria to be used for comparing tables(sheets)
Type name of result sheet or check auto check box
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
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
Tested on Windows 7, and works in same way as on any other windows OS.
You do not need MS Excel or any other software that opens MS Excel files in order to use Compare Sheets. You can review comparison result by opening file in Compare Sheets and selecting sheet containing result.
To use Compare Sheets
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
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
Select reference field by selecting column name for table1 and table2
Select criteria to be used for comparing tables(sheets)
Type name of result sheet or check auto check box
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
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
Tested on Windows 7, and works in same way as on any other windows OS.
You do not need MS Excel or any other software that opens MS Excel files in order to use Compare Sheets. You can review comparison result by opening file in Compare Sheets and selecting sheet containing result.
Link To This File

Comments and Reviews for Compare Sheets 1.1.1
Register now to add a quick comment to this file below or alternatively you can add a more detailed review HERE and include, for example, details such as good/bad points, any specific advantages over similar software, features you found useful and so on. Please be aware that all reviews are subject to a minimum of 150 words and should preferably (but not compulsory) contain screenshots.Your Comments
Register now to add your comments and help others decide if Compare Sheets 1.1.1 could be something of interest of them.- 9,508 Total Files
- 128 Total Categories
- 153 Total Authors
- 1,004,216 Total Downloads
- Notepad++ Latest File
20 user(s) are online (in the past 15 minutes)
0 members, 20 guests, 0 anonymous users
|
|



New Downloads

















