Excel Forum
Similar Content
Get the Row or Column Number of a Cell in Excel
Tutorial: How to get the row or column number of the current cell or any other cell in Excel. This t...
UNIQUE() Function - Excel 365 Function for Removing Duplicates
Tutorial: Excel 365 Formulas Course The new UNIQUE() function for Excel 365 allows you to quickly, ...
Reverse Row or Column Order in a Worksheet
Macro: This macro reverses the order of a selected row or column in excel. It will completely rev...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Array Formula Series #11: ROW & COLUMN functions


See how to create array formulas with the ROW & COLUMN functions in order to create consecutive Integers.

Also see how to use the INDIRECT and ROW function together to create permanent consecutive Integers.

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.