Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Time in hours and minutes between two dates
- Downloads by category
- Taming Symbols in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec…
Tag Archives: Index
Excel functions that return references and new functions
The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading
Slicing Arrays with VBA
A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading
Using Index() as an array function
As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading
Two new blogs
Two new Excel/computer related blogs that I have found recently are: Useful Gyaan (Sharing Stuff to Make life @ work easier) and MS EXCEL UNPLUGGED (which looks like a good resource on using pivot tables) In the near future I will be … Continue reading