Advanced Excel and Remove Duplicates From Excel Software for Windows

Advanced Find & Replace
$29.95 - Afalina Software, Ltd.

Advanced Excel Find & Replace is an add-in for Microsoft Excel 2000, Excel XP (2002) and Excel 2003. It enhances Excel's built-in Find and in addition to all features of the built-in Find allows simultaneous search in values, formulas and comments, search in all opened or selected worksheets and workbooks, free moving around search results, and replacing values in found items. This Excel add-in reduces the number of clicks to one and the search time to a second and adds no new workbooks or VBA macros to your Excel.
All possible manipulations inside the list are allowed:
- you can select the items of interest (or all found items);
- you can replace values in the selected or all items;
- you can search for other values in the selected or all items.

---

---

Advanced Consolidation Manager
$39 - Office Assistance LLC

Advanced Consolidation Manager is designed for merging tables and consolidating Microsoft Excel data. In comparison to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will allow you to process any number of files per one program run as well as to combine data from different files in one.

Advanced Consolidation Manager will help you to consolidate data from different files in one: with grouping by worksheets; by creation of a new worksheet for each file; by creation of one common table; with the performance of calculation: summation, calculation of quantity, calculation of average value, etc.

If you have a number of similar files or you regularly get reports in Microsoft Excel files and you need to consolidate them, Advanced Consolidation Manager can easily solve these tasks. Specify which files and their worksheets to be combined and the location where the results are to be stored - Advanced Consolidation Manager will perform these tasks. The program stores the results either in a common worksheet or in several ones. There is also a possibility to group worksheets in different Microsoft Excel files. For example:

Advanced Consolidation Manager similar to a standard function of data consolidation in Microsoft Excel can consolidate data with the performance of the following calculations:

In contrast to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will enable you to perform the above mentioned operations on the unlimited number of files. Moreover, if files have a similar structure, you can specify a common range which will be applied to all these files. In other words, you can specify one a range of cells which is to be used for consolidation and this range will be used for all selected worksheets.

---

---

Remove Duplicates from Excel
$39 - Office Assistance LLC

Remove Duplicates from Excel is designed for searching and processing duplicated cells in Microsoft Excel tables. Program key functions:
1. Search across columns and rows.
Remove Duplicates from Excel allows you to find duplicated cells in rows or columns. To choose the appropriate search mode, press the corresponding button on the Microsoft Excel toolbar.
2. Search across a table or a specified range of cells.
Remove Duplicates from Excel enables you to search for duplicates across the entire table or a specified continuous range of cells. Start the program for searching the duplicated cells across the entire table or specify a range of cells before launching the program.
3. Search across specified rows or columns.
Advanced mode of Remove Duplicates from Excel allows you to specify the columns or rows to be searched through for duplicates. By default, search is carried out across all rows and columns.
4. Choice of a type of comparison.
Remove Duplicates from Excel compares cells by values or by a formula. This option will allow you to find the cells which contain identical values as a result of calculations.
The following operations over duplicated cells are available: clearing of contents; change of formatting; removal of a row or column with a shift of the table; hiding of a row or column from the current view.

---

MySQL Excel
$38 - softgalaxy

Excel-MySQL converter is a powerful tool to convert any Excel file to a MySQL database or convert any MySQL database to an Excel file utilizing a very easy to use wizard style interface that support so many advanced options like (scheduling,command line support , table selection , field selection,..). The wizard can also store any Excel file into a php script to import it to MySQL even if remote connection to the MySQL server is not allowed . Main features: 1)All versions of MS Excel are supported 2)Works with all versions of Unix and Windows MySQL servers 3)Supports both local and remote connections to MySQL server. 4)Ability to convert the Excel file into MySQL indirectly if you are not allowed to connect your Mysql server remotely 5)Support for scheduling conversion tasks to be performed automatically. · 6)The ability to select only the tables you want convert. 7)The ability to select only the columns you want to convert from each selected table . 8)You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database. 9)Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets 10) Command line support.

---

Excel MySQL converter
$38 - softgalaxy

Excel-MySQL converter is a powerful tool to convert any Excel file to a MySQL database or convert any MySQL database to an Excel file utilizing a very easy to use wizard style interface that support so many advanced options like (scheduling,command line support , table selection , field selection,..). The wizard can also store any Excel file into a php script to import it to MySQL even if remote connection to the MySQL server is not allowed . Main features: 1)All versions of MS Excel are supported 2)Works with all versions of Unix and Windows MySQL servers 3)Supports both local and remote connections to MySQL server. 4)Ability to convert the Excel file into MySQL indirectly if you are not allowed to connect your Mysql server remotely 5)Support for scheduling conversion tasks to be performed automatically. · 6)The ability to select only the tables you want convert. 7)The ability to select only the columns you want to convert from each selected table . 8)You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database. 9)Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets 10) Command line support.

---

Excel-Mysql converter
$38 - softgalaxy

Excel-MySQL is A very powerful tool to convert any MySql database into MS Excel spreadsheets or convert any Microsoft Excel spreadsheets into MySQL databases utilizing easy to use Wizard style interface, Just follow the simple screens and let the wizard automatically do all the work Main features: 1)All versions of MS Excel are supported 2)Works with all versions of Unix and Windows MySQL servers 3)Supports both local and remote connections to MySQL server. 4)Support for scheduling conversion tasks to be performed automatically. · 5)The ability to select only the tables you want convert. 6)The ability to select only the columns you want to convert from each selected table . 7)You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database. 8)Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets 9) Command line support. 10)Ability to convert the Excel file into MySQL indirectly if you are not allowed to connect your Mysql server remotely 11)Ability to append new records in an already existing tables

---