Find
Watch one of the sixteen videos to discover how easily you can build unique lists, identify duplicate data, and search multiple tabs.
- 01) Compare Data Sets. Select Criteria Columns. Last Selected Differentiates b/n Data Sets. Select Value Columns
- 02) Builds Unique List of Values From Selected Cells
- 03) Find A String NOT EQUAL To The String You Select
- 04) Find Duplicates, Marks All But the Last Item Found as ‘Duplicate’
- 05) Find Duplicates, Marks All as ‘Duplicate’
- 06) Find Items Having Exact Offsets Based on One or More Criteria COLS and One Or More Value COLS
- 07) Looks For Your String in All The Tabs of Active Workbook
- 08) Looks For Calc Errors in All The Tabs of Active Workbook
- 09) Looks For Comments in All The Tabs of Active Workbook
- 10) List All the Files Under a Chosen Path
- 11) Build Search List Supplying Your Own Data or SQL Statement
- 12) Trace Dependents For Selected Cells
- 13) Build Amortization Schedule
- 14) Find MOST Data Sources Associated With Active Workbook
- 15) Find ALL Connection Strings in Already Opened ACCESS File
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc