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 18.104.22.168 may include unspecified updates, enhancements, or bug fixes.
||Free to try
||Windows 95/98/Me/NT/2000/XP, Microsoft Excel 2000