The ASAP Utilities menu in Excel (English)
Fast calculation on selected cells...
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Information › 1. Fast calculation on selected cells...
This utility performs a fast calculation on the selected data range.The utility shows you the following information:
You can choose to have a new workbook created with these results.
Note:
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.
Screenshots
Example screenshot: 1
Example screenshot: 2
Practical tricks on how this can help you
Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!Starting this tool
- Click ASAP Utilities › Information › 1. Fast calculation on selected cells...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Additional keywords for this tool:
Double, duplication, dedupe, deduplicate, undouble
Double, duplication, dedupe, deduplicate, undouble
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years