Tag Archives: Array Formula

Using conditional formatting with array formulas

Posted on 17/08/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 09/09/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