| Version | 7.1.3.3 |
|---|---|
| Publisher | Excel Add-ins |
| Release date | Nov 8, 2008 |
| Date added | Jan 9, 2007 |
| Os requirements | Windows 95, Windows 2000, Windows 98, Windows Me, Windows, Windows XP, Windows NT |
| Requirements | Windows 95/98/Me/NT/2000/XP, Microsoft Excel 2000 |
| Total downloads | 92,050 |
| Downloads per week | 2 |
| Price | Free to try |
Description
Use this Excel add-in to remove duplicates. Remove by list matching or key fields; do Access-like query, aggregation, join; simplify pivot table with a roll-up that outputs in simple list; enhance pivoting and subtotal to aggregate in 21 statistical functions such as median and count of unique values. Use this add-in to find and fix broken links; set complex filters; filter blank, exclude, invert, filter within filter; merge or join tables; sort list by multiple levels; special sort by text, color, or style. Use this add-in to fill range by random values or linear series; delete, insert by intervals; convert date values, data types, and cases; extract valid e-mail addresses and filter result; append tables to form a master list; split table by values in columns or number of rows. Use this add-in to mix, match, combine sets of values; transpose, combine, split, trim columns.
Version 7.1.3.3 may include unspecified updates, enhancements, or bug fixes.
Review
Excel is already an enormously powerful tool, but DigDB provides a handful of extra functions that can make a spreadsheet easier to use. We particularly liked the Filter, Roll up, and Sort features that allow users to do queries similar to SQL functions in an easy-to-use interface. In many cases we found these commands more convenient and powerful than Excel's own Pivot and Subtotals.
Another useful feature provides the ability to split columns--extracting first and last names into separate columns, for example. In our tests the program worked smoothly and quickly, even with large tables, although the lack of a help file might give some new users pause. Overall, we see DigDB as a potentially significant help to people who work with large spreadsheets.
