Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Downloads
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Dancing Pendulums
Recent Comments
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