Recent Comments
Stan on ALGLIB linear and polynomial f… 
dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder 
Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… 
GP on Weighted Least Squares Regress… 
Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update 
angelgalvanc on 3D Frame Update More on Numba | Newt… on Making Finite Element Analysis… dougaj4 on Writing Arrays to the workshee… 
Jorge on Writing Arrays to the workshee…
Tag Archives: Array Formula
Using conditional formatting with array formulas
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 Array Formula, conditional formatting, Excel, Office Insider
Leave a comment
Using the DMax Function …
… 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
