Add-ins Collection for Excel

12 add-ins included in the Collection for Excel

Add-in	Short description
Duplicate Remover	Find and remove thousands of duplicates or unique entries in seconds. Search through spreadsheets with up to 1 million rows, choose any columns for comparison.
Merge Tables Wizard	Combine matching data from 2 Excel worksheets into one in seconds. Easy-to-understand alternative to Excel Vlookup function.
Combine Rows Wizard	Merge data from duplicate rows into one based on the selected key column or columns. Combine all values or pull unique data only ignoring duplicates and skipping empty cells.
Merge Cells Wizard	Merge cells, rows and columns in a click. All data are preserved even if the selection contains multiple values.
Fuzzy Duplicate Finder	Search and correct partial duplicates, similart records, misprints and typos from Excel worksheets.
Advanced Find & Replace	Search in all or selected worksheets at a time. Simultaneous search in values, formulas, comments and hyperlinks.
Random Generator	Generate unique random numbers, strings, dates, passwords and Boolean. Fill the range randomly with custom list values.
Random Sorter	Shuffle individual cells or entire rows and columns; get a random sample of your data.
Split Names	Split a column of names into individual cells: names, salutations, suffixes etc.
Units Converter	Perform various conversions between more than 200 measurement units in 18 different categories.
Workbook Manager	Navigate between multiple workbooks with comfort and ease. Rename, delete, sort your worksheets in a click.
Cell Cleaner	Delete excess spaces and line breaks, change case, convert numbers formatted as text to numbers & more.

Collection add-ins work in Excel 2003 - 2010

How to install the add-in for several users

1. The setup files of all our add-ins are Windows installer packages (.MSI) and they support all Windows Installer command-line options.
2. The add-in is installed only for the current user account, not for all users of the system.
3. The license is per user, not per machine. You can install the add-in on 3 machines of the same user.
4. Add-ins are installed into the user's personal folder, administrative or power-user permissions are not required.
5. Our add-ins are compatible with all personal and server operating systems starting with version 2000.
6. To track installations we use the online activation system on our activation server. The activation key is bound to the Hardware ID, which is a combination of hardware serial numbers.
7. Single Terminal Server. Our add-ins work fine.
8. A group of Terminal Servers with load balancing, a user has a roaming profile. Since activation is bound to the Hardware ID, it is lost every time the user switches to a new server. The good news is that it is solvable :-), please contact us. 

1. Download the latest version of the setup file (Download)
2. Unpack the downloaded setup file to any folder.
3. Run the setup in order to create a network image. To do this, enter the following string into the command line:
   msiexec /a excel-addins-collection.msi
4. This will run the Setup wizard. On step 3 called "Installation settings", browse for a network folder in which a network image will be created. Enter your Registration name and Registration key in the corresponding fields. It should look similar to this: 
   
5. Finish the process and wait until the network image is created.
6. You can create a network image silently. If you dislike working with wizards and want to save some more time, you can specify the setup folder and license info in the command line when running the setup file. Here are the command-line options (switches):
   TARGETDIR="setup folder" REGISTRATIONNAME="" and REGISTRATIONKEY="" - your license information.
   Here is how it looks in our example:
   msiexec /a excel-addins-collection.msi TARGETDIR="Z:_Setups\Ablebits Add-ins Collection for Excel" REGISTRATIONNAME="Add-in Express Ltd." REGISTRATIONKEY="EACL2-XXXXX-XXXXX-XXXXX-XXXXX-XXXXX"
   In this case the wizard will not disturb you; it will go unnoticeable and create a network image in the specified folder silently.

1. Add a rule for activatenow.com to your firewall settings , or
2. Ask your users to activate the add-in manually. To do this, they need to click the key icon at the bottom of the add-in's window or pane, choose "Manual Activation" and click the Go button on the next step. The activatenow.com page containing the activation code will open in their browser. They need to copy it and paste into the "Activation code" field, then click Next.