|
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: 23/2025
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
|
