The ADDRESS function in Excel creates a cell reference as text based on a given row and column number. By default the ADDRESS function creates an absolute reference.
This example shows you how to create an array formula that counts unique values in Excel. In Excel 365/2021 use UNIQUE and COUNTA to count unique values.
Use the FIND function in Excel to find the position of a substring in a string. The FIND function is case-sensitive.
Excel stores and calculates floating point numbers. Sometimes the result of a formula is a very close approximation.
Use the magic SORT function in Excel 365/2021 to sort your Excel data by one column or multiple columns. Let's give it a try.
A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.
What's compound interest and what's the formula for compound interest in Excel? This example gives you the answers to these questions.
Below we will look at a program in Excel VBA that writes an Excel range to a CSV (comma-separated-value) text file.
You can lock cells in Excel if you want to protect cells from being edited. By default all cells are locked. However locking cells has no effect until you protect the sheet.
The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria.
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.
