Excel functions such as SUM COUNT LARGE and MAX don't work if a range includes errors. However you can easily use the AGGREGATE function to fix this.
Use MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.
Use Instr in Excel VBA to find the position of a substring in a string. The Instr function is quite versatile.
To quickly enter a GETPIVOTDATA function in Excel type an equal sign (=) and click a cell in a pivot table. The GETPIVOTDATA function can be quite useful.
This example shows you how to create an array formula that counts the number of errors in an Excel range.
To lookup a value in a two-dimensional range use INDEX and MATCH in Excel. Below you can find the sales of different ice cream flavors in each month.
This article teaches you how to randomize (shuffle) a list in Excel. For example let's randomize the list in column A below.
This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons.
Inserting a checkbox in Excel is easy. For example use checkboxes to create a checklist or a dynamic chart. You can also insert a check mark symbol.
When Scroll Lock is turned on you can use the arrow keys to scroll through the worksheet without changing the active cell. Excel displays Scroll Lock in the status bar.
Excel meets AI – Boost your productivity like never before!
At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.
Categories
113
49
16
Ready to Get Started?
Improve your proficiency in spreadsheets, increase your productivity and eliminate the challenges associated with intricate calculations and formulas for good.
