Excel Row - Free Excel Tutorial - Part 2

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 »

Copy and Paste Only Non-blank Cells

This post will guide you how to copy and paste only non-blank cells in Excel 2013/2016. How do I copy only non blank cells with VBA code in Excel. Or how to get non-blank cells from a range of cells with a formula in Excel. This post will introduce four methods to copy and paste… 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 »

Removing Non Numeric Characters

This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. Or how to strip out non-numeric characters from a given cell in Excel. Removing Non… 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 »

Split Data in One Column to Multiple Columns

This post will guide you how to split data in a single column into multiple columns with a formula in Excel. How do I transpose data from one column to multiple columns in Excel. How can I make one long column into multiple columns in Excel. Split Data in One Column to Multiple Columns Assuming… read more »

Sum Numbers from 1 to N

This post will guide you how to sum the numbers from 1 to N in Excel Worksheet. How do I sum the integers from 1 to N with an excel formula. How to write an excel formula to calculate 1+2+3+…+N in excel. Normally, we can use the SUM function to sum a list of numbers… read more »

Delete Every Other Row

This post will guide you how to delete every other row by filter command in Excel. How do I delete every other row in a selected range on a worksheet by Excel VBA Macro. Delete Every Other Row with Filter command To delete every other row in Excel, you need to filter alternate rows, and… read more »

Transpose Multiple Columns into One Column

This post will guide you how to transpose multiple columns into a single columns with multiple rows in Excel. How do I put data from multiple columns into one column with Excel formula; How to transpose columns into single column with VBA macro in excel. Assuming that you have a data list in range B1:D4… read more »

How to Get the List of File Names From a Folder

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get the list of file names with different ways, such as: Excel VBA Macro, or FILES… read more »

How to find nth Occurrence with Multiple Criteria Using INDEX/MATCH

This post explains that how to get the nth occurrence value with multiple criteria using INDEX and MATCH in excel. How to find the first, second or nth match with multiple criteria in excel. How to return the nth match on a multiple criteria using INDEX and MATCH. In the previous post, we talked that… read more »

How to get nth Match with One Criteria using INDEX/MATCH

This post will guide you how to get nth match based on one criteria with INDEX and MATCH in Excel. In the previous post, we used one excel formula to get the position of the nth occurrence of a value based on one criteria, at this moment, we can also use it in the new… read more »

How to Reverse a List or Range

This post will guide you how to reverse a list of values or a range of values in excel. How to reverse the order of a column data or a list of items using excel formula. How to reverse a range with sort command. How to reverse a list or column value with VBA. Reverse… read more »

How to Create an Array of Numbers

This post explains how to return an array of numbers using an excel formula in excel. Create an Array of Numbers If you want to create an array of numbers, you can use a combination of the ROW function, the INDIRECT function or OFFSET function or INDEX function or MIN function to create a new… read more »

Three Ways to Get the Last Row Number in a Range

This post explains that how to get the last row number in a range or a table in excel. Sometimes, you want to know the last row number for a excel range. The below will guide you how to get the last row number in range using excel formula through the following three ways: Get… read more »

Sidebar