logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Fast calculation on selected cells...

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

Information  ›  Fast calculation on selected cells...

This utility performs a fast calculation on the selected datarange.

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.

    Remark:
    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
    1, Information  ›  Fast calculation on selected cells...
    Example screenshot: 2
    2, Information  ›  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


    Download
    Additional keywords for this tool:
    Double, duplication, dedupe, deduplicate, undouble
    Easily create a lot of folders based on the values in selected cells...



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