Tag Archives: Array Formula

Using conditional formatting with array formulas

Posted on August 17, 2019 by dougaj4

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“.  The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading →

Posted in Arrays, Excel | Tagged , , , | Leave a comment

Using the DMax Function …

Posted on September 9, 2009 by dougaj4

… and an alternative. In this discussion at Eng-Tips I recommended the use of the DMAX() function to extract maximum values from data grouped with different text labels.  In the process I needed to adjust the selection criterion to generate the … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 4 Comments