My post from last week, on using the Aggregate function to find the maximum and minimum of a range ignoring errors, was linked in the Contextures Blog’s weekly roundup, which also linked to the Contextures page of Sum Function examples. This includes sub-totals, grand-totals, Offsets, Sumifs, Sumproducts, and much more. It’s a comprehensive list, including clear examples and videos, and well worth a visit.
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Beam geometric non-linear effects
- Fine as a Bee's wing
- Drawing in Excel 7 - Creating drawings from coordinates
- Lateral pile analyis with PY curves ...
dougaj4 on Beam geometric non-linear… Bob Jordan on Beam geometric non-linear… David Lim on Frame Analysis Resources dougaj4 on About Newton Excel Bach Jeremy on About Newton Excel Bach dougaj4 on Plotting Charts With Gaps… Jon Peltier on When is an XY chart not an XY… Lori on Plotting Charts With Gaps… dougaj4 on When is an XY chart not an XY… dougaj4 on Plotting Charts With Gaps… Kari Mahaffy on Solving simultaneous equations Cameron Wallace on Plotting Charts With Gaps… Bill Harvey on When is an XY chart not an XY… Bill Harvey on Plotting Charts With Gaps… Plotting Charts With… on When is an XY chart not an XY…