DigDB Excel Add-in Toolkit

Domain: www.DigDB.com
Categories: Excel Utilities

Excel Add-ins for Power Users. Enhance Excel filter and pivot table, merge tables, find duplicates, sort, convert. A simple alternative to Access.

Rating: 1.00

(1 votes)
Added: 07-30-2004 - Updated: 11-07-2004 - Comments: 0 - Hits month/total: 2/2209
Report error

Version (if applicable): 2000 or Later

Use this Excel add-in toolkit to empower yourself. It removes duplicates - you can dedupe by matching one table against another, or filter, count, purge duplicates by key fields. You can do Access-like query, aggregation, and join. It simplifies pivot table with a one-step summary, no file size inflation, and simple table output. Enhanced pivoting and subtotal let you compute median, count/show unique values, and aggregate by 21 other stat functions, to generate sophisticated summaries that can be further queried or summarized.

You can use it to:

find and fix broken link
set filters with multiple complex criteria and filter blank, exclude, or invert
merge or join table
sort table randomly or by any number of fields
fill range with random numbers or dates
delete empty rows and columns
convert text and date
extract visible rows
transform table by difficult split, transpose, column shift

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.