Select and Filter in Excel application of Optipe Data Tools Suite adds a number of tools to select and filter Excel cells by various criteria or conditions, expanding possibilities for users.
Cell selection is one of the most common and recurring activities for any Excel user, which however, is performed most of the time manually, resulting in inefficiencies.
Use this application to:
- Select cells automatically, ignoring the do it manually.
- On the selected cells, you can use many Excel commands, such as copy, cut, delete, fill, or insert a new value.
- Filter or mark the cells, for the selection type chosen.
- This application can be a great help to debug data tables, as their versatility to select cells by various criteria, you will act on the selected cells (change its value, delete, copy, color the cells) or the rows in which they they are (delete, cut or add rows).
Features:
- You can select the entire table, the column or row.
- Use the following selection options:
- Cells with numerical constants
- Repeated cells
- 1st occurrence of each value
- 2nd cccurrence or more of each value
- Cells with Text
- Cells with a certain fill or font color
- Dependent cells
- Precedent cells
- Cells with error messages
- Blank or empty cells
- Cells with Conditional Format
- Visible Cells
- Cells with Comments
- Cells with Hyperlinks
- Cells with Font Style (Normal, Italic, Bold, Bold Italic)
- Cells with Formulas (all or those containing some text)
- Cells with values that match a condition
- Cells with higher or lower values.
- Optionally, on selection you can:
- Mark the cells with a color
- Extend the selection to the entire row
- Add a mark in the last column
- Filtering cells
See also:
Examples:
Video Example. Select cells with numeric constants and cells with text.
Video Example. Select 1st occurrence of each cell and repeated cells.
Video Example. Delete rows with cells that contain repeating values in a column.
Video Example. Select dependent and precedents cells.
Video Example. Select cells with error messages.
Video Example. Delete rows that contain empty cells.
Video Example. Copy the rows of cells with fill or font color or cells with some style.
Video Example. Copy rows of visible cells.
Video Example. Select cells with comments.
Video Example. Select the values that meet certain criteria.
Video Example. Select cells whose formulas meet certain criteria.
Video Example. Copy rows of 3 lowest values.
Video Example. Filter on selected values.
