This group of macros helps with finding patterns or symbols in cells and cell ranges. Like most of macros in SEMTools, these operate with selected list of cells.
How to use
Select a list of cells and press button responsible for the macro you wish to execute. The result is always TRUE or FALSE. This is useful in cases when you need to perform a quick research of selection and further actions are not yet needed.
Finding approach is also useful because you have only 2 options to choose from.
TRUE and FALSE, then you can filter and count, choosing between these 2 options. Fast and easy.
Imagine you already know that all cells must contain some pattern. Or one of several patterns. Or it must contain all of them.
Checking with find pattern functions, you can find anomalies in your data. Quick filter by TRUE or FALSE will help you see those mistakes all at once and understand what to do next.
Fast-pivoting TRUE-FALSE results
Before taking decisions on what to do with data, it might be useful to count how cells that match or don’t match your criteria, are distributed.
To do this, you can create a fast pivot table.
Objects to find with !SEMTools find tools
At this moment 4 types of objects can be found with !SEMTools — submenus are created for each:
- Find symbols — check if cell contains specific characters
- Find words — check if cell contains specific words
- Cells — these operate with full cell content, which helps find patterns including space character, usually those are some phrases.
- Duplicates — as these ones are very popular and stand a little bit out of the croud. See the description to find out more on this.