ExcelHow

Tag: excel INDEX

Three Ways to Get the Last Row Number in a Range

Excel Examples

July 22, 2024
How to Get the List of File Names From a Folder

Excel Basics, Excel Examples

July 3, 2024
How to Dynamically Extract Unique Values from A Column List in Excel

Excel Examples, Excel VBA

June 24, 2024
How to Extract all Partial Matches

Excel Examples

June 23, 2024
How to Generate Random Values by a List in Different Cases in Excel

Excel Examples

June 5, 2024
How to Create Dynamical Drop-Down List and Sort by Alphabetical Order in Excel

Excel Examples

May 31, 2024
How to Find the First or Last Non-blank Cell in a Row or Column in Excel

Excel Examples

May 22, 2024
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