logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

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 utility

    In the Excel menu choose: ASAP Utilities » Information » Fast calculation on selected cells...

    « Return to the list of “Information” tools.
    « Previous
    Easily create a lot of folders based on the values in selected cells...
     
     Next »
    File and selection info...
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utilities
    Additional keywords for this tool:
    Double, duplication, dedupe, deduplicate, undouble

    Follow ASAP Utilities on Facebook



  • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    © 1999-2017 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook