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.
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Cubic Splines
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Retrieving unique values from a range or array ...
tim on Strand7 API GetNode funct… dougaj4 on Converting from global to loca… Nour on Converting from global to loca… rajith on Running exe files from Ex… dougaj4 on What is VBA good for? … Kazahk SON on What is VBA good for? … #Excel Super Links #… on Solving non-linear equations w… Using Matplotlib fro… on Use Matplotlib from Excel with… #Excel Super Links #… on More on trend line equations o… dougaj4 on Strand7 API GetNode funct… Pietro on Strand7 API GetNode funct… dougaj4 on Non-linear Frame Analysis Arend van Wijngaarde… on Non-linear Frame Analysis dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi…