Excel Column

How To Increment Cell Reference by X Rows in Excel

This post will guide you how to increment cell reference by x Rows when you drag a formula to populate cells in a column in Excel. By default, when you drag the AutoFill Handle down to other cells , the cell reference in the formulas will be increated by one. And if you want to… read more »

How to Get the Active Cell Address in Excel

This post will guide you how to get the active Cell address with a formula in Excel. How do I return address of active cell with a VBA Macro in Excel. Get the Active Cell Address with Formula Get the Active Cell Address with VBA Get the Active Cell Address with Formula If you want… read more »

How to Convert Multiple Rows into a Single Row in Excel

This post will guide you how to convert multiple rows or columns into a single row with a formula in Excel 3013/2016. How do I convert groups of rows to a single row of columns with VBA Macro in Excel. Convert Multiple Row into Single Row with Formula Convert Multiple Row into Single Row with… read more »

How to convert Column Letter to Number in Excel

This post will guide you how to convert column letter to number in Excel. How do I convert letter to number with a formula in Excel. How to convert column letter to number with VBA macro in Excel. How to use a User Defined Function to convert letter to number in Excel. Convert Column Letter… read more »

Sum Every Nth Row or Column

This post will guide you how to sum every nth row or column with a formula in Excel. How do I sum every nth value in a same row or column in Excel. How to sum every nth cell in a column or in a row with an Excel Formula. How to sum every second,… read more »

VLOOKUP Return Multiple Values Horizontally

This post will guide you how to vlookup a value and then return multiple corresponding values horizontally in Excel. How do I lookup a value and return multiple matched values in the same row in Excel. Or how to return multiple values with VLOOKUP function in Excel. VLOOKUP Return Multiple Values Horizontally Assuming that you… read more »

How to convert column letter to number

This post will guide you how to convert a column letter to a column number using an excel formula. And how to write a user defined function to convert column letter to number in excel VBA. Convert column letter to number using excel Formula If you want to convert a column letter to number, you… read more »

Excel Column Function

This post will guide you how to use Excel COLUMN function with syntax and examples in Microsoft excel. Description The Excel COLUMN function returns the first column number of the given cell reference. The COLUMN¬†function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The COLUMN¬†function is… read more »

Sidebar