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.
Price USD39
License Free to try
File Size 867.57 kB
Version 7.1.3.3
Operating System Windows 95 Windows 98 Windows Me Windows NT Windows Windows 2000 Windows XP
System Requirements Windows 95/98/Me/NT/2000/XP, Microsoft Excel 2000