DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Select cell(s) that is the Maximum or Minimum value in an area, or in each row or column of an area

  1. Select an area in a sheet first. If you don't select an area, then DigDB will auto-select the current neighboring region.

    Select cells - Maximum (max), Minimum (min)
    Practice file - select-max-min-demo.xls (16k)

  2. Invoke 'DigDB->Selected Area->Select Cells->Max->Numbers->...', you have several options

    Select cells - Maximum (max), Minimum (min)

  3. 'DigDB->Selected Area->Select Cells->Max->Numbers->Of All' = select the cells that has the Maximum number value in the selected range,

    Select cells - Maximum (max), Minimum (min)

  4. 'DigDB->Selected Area->Select Cells->Max->Numbers->by Row' = select the cells that has the Maximum number value in each row of the selected range

    Select cells - Maximum (max), Minimum (min)

  5. 'DigDB->Selected Area->Select Cells->Max->Numbers->by Column' = select the cells that has the Maximum number value in each column of the selected range

    Select cells - Maximum (max), Minimum (min)

    Same with Dates and Minimum values. DigDB has many other Select Cells features that allow you to select by wild card, by multiple nested criteria, or by data types. After the cells are selected, you can also expand selection to include the entire row or column for further data manipulation.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (free forum)

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.