ExcelHow

Tag: excel INDEX

How to Randomly Select Cells

Excel Examples

April 14, 2024
How to Flip a Column of Data Vertically

Excel Examples

April 11, 2024
How to List all Worksheet Names

Excel Examples

March 31, 2024
How to find nth Occurrence with Multiple Criteria Using INDEX/MATCH

Excel Examples

March 24, 2024
How to Extract Number from Text String in Excel

Excel Examples, Excel VBA

February 11, 2024
How to Create an Array of Numbers

Excel Examples

January 19, 2024
How to Find and Replace Multiple Values

Excel Examples, Excel VBA

January 9, 2024
How to Find Most Common Value in a Range in Excel

Excel Examples, Excel VBA

January 4, 2024
How to VLOOKUP Return Multiple Values Horizontally

Excel Examples

December 24, 2023
How to Extract multiple match Values into different Columns or Rows

Excel Examples

December 2, 2023
How to Create Dynamic Drop Down List without Blank in Excel

Excel Examples

November 26, 2023
Excel nested if statements with ranges

Excel Examples, Excel Logical Functions

November 26, 2023
How to Pick a Random Name from a List in Excel

Excel Examples

November 5, 2023
How to Transpose Multiple Columns into One Column

Excel Examples

November 5, 2023
How to Return Cell Address Instead of Value in Excel

Excel Examples

November 5, 2023
How to Sum Specific Row or Column in Named Range

Excel Examples

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

Excel Examples

October 29, 2023
How to Copy and Paste Only Non-blank Cells in Excel

Excel Examples, Excel VBA

October 29, 2023
How to Extract a Unique List based on Criteria in Excel

Excel Examples

October 21, 2023
How to Generate All Possible Combinations of Two Lists in Excel

Excel Examples

October 21, 2023