Excel Row

How to Move Every Other Row to a New Column in Excel

This post will guide you how to move every other row to a new column in Excel. How do I move every odd row to another column with formula in Excel 2013/2016. How to move every even row to other column in Excel with VBA Macro in Excel. Move Every Other Row to New Column… 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 Remove Numbers from Text in Excel

This post will guide you how to remove all numbers from a text string in one cell in Excel. How do I strip all numeric characters from a given cell with a formula in Excel. How do I remove numbers from cells with text using a User Defined Function in Excel. Remove Numbers From Text… read more »

How to Get the First, 2nd or Nth Match Using Vlookup/Index/Match

This post will guide you how get the nth matching values with VLOOKUP function in Excel. How do I find the nth match value with Index/Match formula in Excel. How to find the first, second, third or nth matching value from a range of cells using VLOOKUP formula. Find the First Match Value Using VLOOKUP… read more »

How to Copy Value of Same cell From Multiple Worksheets in Excel

This post will guide you how to copy value from same cell on multiple worksheets in your workbook in Excel. How do I List values of same cell reference from multiple worksheets with a formula in Excel. How to copy data from the same cell of multiple worksheets with VBA Macro in Excel. How to… read more »

Reverse Text String in Excel

This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in Excel. Reverse Text String with User Defined Function You can easily write down a User… read more »

Find Missing Numbers in a Sequence in Excel

This post will guide you how to find missing numbers in a sequence with a formula in Excel. How do I identify missing numbers in a consecutive series in Excel. How to find missing serial number in Excel 2013/2016. Find Missing Numbers in a Sequence in Excel Assuming that you have a serial number list… read more »

Generate All Possible Combinations of Two Lists in Excel

This post will guide you how to generate all possible combinations with a formula in excel. How do I create list with all possible combinations of two lists in Excel. How to list all combinations from two separate list or range in Excel. Generate All Possible Combinations of Two Lists in Excel Assuming that you… read more »

Sidebar