logo ASAP Utilities

User Guide

The ASAP Utilities User Guide is a practical manual that will show a detailed description of all available tools. It helps you to get the best out of this excel add-in

Search within the ASAP Utilities tools

Language: English Nederlands (Dutch) Deutsch (German) Español (Spanish) Français (French)

Find a utility containing the following words in English:



Notice: Undefined index: HTTP_REFERER in /domains/asap-utilities.com/DEFAULT/includes/functions7.inc.php on line 441

7 utilities were found:

The following utilities contain your search term(s), sorted by their position in the menu and their name:

1. Select » Select cells based on content, formatting and more...

With this tool you can select cells based on their value, formatting style and other properties.
You can for example select all cells between 50 and 250 or all bold cells or all red cells.

You can use the following criteria to select cells based on their contents:
-  between
-  not between
-  equal to
-  not equal to
-  greater than
-  less than
-  greater than or equal to
-  less than or equal to
-  begins with
-  does not begin with
-  ends with
-  does not end with
-  contains
-  does not contain
-  like (text, with use of wildcard characters)
-  not like (text, with use of wildcard characters)
-  duplicate values
-  unique values
-  empty cells
-  not empty cells
-  FALSE
-  TRUE
-  text length
-  values in lowercase
-  values in UPPERCASE
-  odd numbers
-  even numbers
-  number (constant)
-  number (formula)
-  number (link to sheet)
-  number (link to file)
-  formula with reference to file
-  formula with reference to sheet
-  contains any of the values specified in a range
-  contains any of the full words specified in a range
-  does not contain any of the values specified in a range
-  does not contain any of the full words specified in a range
-  equals a value specified in a range
-  does not equal a value specified in a range
-  contains all values specified in a range
-  contains all full words specified in a range

You can use the following criteria to select cells based on formatting and more:
-  cell color
-  font color
-  font name
-  font size
-  font = bold
-  font <> bold
-  font = underline
-  font <> underline
-  font = italic
-  font <> italic
-  strikethrough
-  has hyperlink
-  has comment
-  protected cells
-  unprotected cells
-  odd rows
-  even rows
-  odd columns
-  even columns
-  visible cells
-  hidden value/formula
-  number format contains
-  merged cells
-  unmerged cells

You can use the following criteria to select cells based on their date:
-  between
-  not between
-  equal to
-  not equal to
-  greater than
-  less than
-  greater than or equal to
-  less than or equal to
-  Weekday
-  Month
-  Year
-  Quarter

Some people use this utility as an alternative for or addition to Excel's AutoFilter.

By default this utility can be used with the shortcut Ctrl+Alt+O.

Remark:
The speed of the utility decreases if the matching cells are in many non-contiguous blocks of cells. The speed can be increased by first sorting your data.
You cannot use this utility to select cells on a condition that is set via conditional formatting.
Due to a limit in Excel, this utility can select a maximum of 8192 non-contiguous blocks of cells. More information about this is on the Microsoft website:
http://support.microsoft.com/kb/832293/en-us

(additional keywords: Duplicates, Double, Colour, Based on criteria, highlight, duplicate data, duplicate fields, duplicate cells, find all duplicates, filter, select rows or columns in intervals, colours, find and select cells that meet specific conditions, wildcard, match, tough filter, find cells with a certain amount of characters, finding, duplication, Conditional select cells, the same value, colored, highlight, line, advanced, amount, quantity, see, tag, select within, choose, pick, underlined, blanks, deselecting, unselect, separators, only, white, pink, red, orange, brown, yellow, gray, green, cyan, blue, violet, black)

2. Select » Conditional row and column select, hide or delete...

This utility allows you to select, hide or remove rows or columns based on a certain condition.

You can use the following criteria to select, hide of remove the entire rows or columns:
-  between
-  not between
-  equal to
-  not equal to
-  greater than
-  less than
-  greater than or equal to
-  less than or equal to
-  like (text, with use of wildcard characters)
-  not like (text, with use of wildcard characters)
-  duplicate values (you can choose to keep the first value)
-  unique values
-  odd rows
-  even rows
-  every n'th row number
-  odd columns
-  even columns
-  every n'th column number
-  empty cells
-  completely empty rows
-  completely empty columns

With the criteria for text and duplicate or unique values you can choose if you want the utility to be case sensitive.
When looking for duplicates the program also searches in hidden cells in your selection, with the other search options hidden cells are skipped.

Some people use this utility as an alternative for or addition to Excel's AutoFilter.

(additional keywords: Delete every second row, Double, Based on criteria, Duplicate lines,highlight , filter, select rows or column in intervals, duplication, the same value, highlight, line, select within, choose, pick, dedupe, deduplicate, undouble, blanks, delete blank rows, blank lines, only)

3. Range » Clear duplicated values in selection (leave one original)

This utility will remove all duplicated values within the selected cells and keep one original.
The first cell containing a duplicated value will keep its value, all other cells with this same value will have their contents cleared.
This way only one of each value will remain.

You can specify if you want this utility to be case sensitive.

If your selection contains formulas then this utility compares the calculated values. This means that this utility considers a cell with the value 12 and a cell with the formula =3*4 as a duplicate.

(additional keywords: Double, duplicate data, duplicate fields, duplicate cells, undouble, dedupe, deduplicate, undouble list, delete, del, duplication, double entries, the same value, Empty duplicates in selection, clear, remove, doubles, dedupe, deduplicate, undouble)

4. Range » Count and/or color duplicates in selection...

This utility tells you how many duplicate values there are in your selected range.
You can choose to paint all duplicate cells with a certain color.

Remark:
The utility is case sensitive which means for example that "Excel" and "EXCEL" are not the same.
If your selection contains formulas then this utility compares the calculated values. This means that this utility considers a cell with the value 12 and a cell with the formula =3*4 as a duplicate.

(additional keywords: Double, Colour, duplicate data, duplicate fields, duplicate cells, colours, flag duplicate values, finding duplicates, find, duplication, see, tag, dedupe, deduplicate, undouble)

5. Range » Count duplicates and give each set of duplicates its own color

This tool counts and colors the duplicate values in your selection.
Each set of duplicated values is given its own unique color.

This helps to quickly find the duplicated values, by having a set of colors each of which can readily be distinguished from one another.

Example:
If your selection contains 5 cells with the value "London" then those 5 cells will all get the same color, for example blue. And if the value "Paris" exists in 3 cells then those 3 cells will also get the same, but a different color, such as green.

Remark:
The utility is case sensitive which means for example that "Excel" and "EXCEL" are not the same.
If your selection contains formulas then this utility compares the calculated values. This means that this utility considers a cell with the value 12 and a cell with the formula =3*4 as a duplicate.

6. Numbers & Dates » Random numbering of cells (without duplicates)

This utility fills the selected cells with unique random integers.

This can be useful if you want to quickly create a list of random numbers without duplicates.
The lowest created number in the list is 1 and the largest number is the number of cells in your selection.

(additional keywords: random number generator)

7. Information » Fast calculation on selected cells...

This utility performs a fast calculation on the selected datarange.

The utility shows you the following information:
-  the number of selected cells
-  the number of numeric cells
-  the number of text cells
-  the number of blank cells
-  the sum
-  the average
-  the minimum value
-  the maximum values
-  the number of duplicates (values that appear more than once)
-  the number of unique values
-  values that appear only once

You can choose to have a new workbook created with these results.

Remark:
The following rules apply for counting the duplicates and unique values:
The utility is case sensitive which means for example that "Excel" and "EXCEL" is not the same.
If your selection contains formulas then this utility compares the calculated values. This means that this utility considers a cell with the value 12 and a cell with the formula =3*4 as a duplicate.

(additional keywords: Double, duplication, dedupe, deduplicate, undouble)


Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2019 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook