PATools Data Toolkit for Excel 4.20 (for Excel)
PATools Data Toolkit
This popular and powerful add-in gives you many more tools with which to manipulate and analyse data in Microsoft Excel software.
Find almost any selection of cells on a sheet (by their appearance, contents or location), and carry out some selected function on them, such as change the appearance, the contents or the location
Work easily with duplicates, links, errors, colours, formats, hyperlinks etc
Convert numbers or formulae easily
Tidy up text and convert numbers which have been input as text (aren’t they annoying?!!!)
Find missing items from lists of data
Line up and compare two sets of data next to each other on one worksheet
Add a clickable index page to your workbook
Convert digits into words
Swap instantly a block of data with the block adjacent (instead of having to insert, cut and paste and delete)
PLUS much, much more …
In addition it takes just one click to
see instantly the sum, average, sum of positives and negatives separately (useful for accountants to see Debits & Credits), maximum and minimum values of your selected area even if it contains error cells.
see instantly an analysis of your selected cells in terms of the number of cells, and the number that contain formulae, values, positive values, negative values, zeros, errors, text, blank and non-blank cells.
The reason this is so useful is that (unlike the bar at the bottom of the normal screen) it shows you all the figures in one go, and it copes with error cells (see how the built-in Excel bar changes as soon as you shade over an error cell?).