logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Fast calculation on selected cells...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

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:
  • 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.

    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.


    Example screenshot: 1
    1, Information  ›  1 Fast calculation on selected cells...
    Example screenshot: 2
    2, Information  ›  1 Fast calculation on selected cells...
    ASAP Utilities makes YOU rock in Excel!

    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

    Information  ›  1 Fast calculation on selected cells...
    Additional keywords for this tool:
    Double, duplication, dedupe, deduplicate, undouble

  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us

    Empowering Excel Users Worldwide for 25 Years