ExcelHow

Tag: excel INDEX

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
How to Average Absolute Values in Excel

Excel Examples

September 21, 2023
How to Look up Value and Return Adjacent Cell Value in Excel

Excel Examples

July 9, 2023
How to Find the First or Last Positive or Negative Number in a Column/List in Excel

Excel Examples

June 25, 2023
How to Transpose Values Based on the Multiple Lookup Criteria

Excel Examples

April 17, 2023
How to Concatenate Text based on unique values in Another Column in Excel

Excel Examples, Excel VBA

April 17, 2023
How to Find the Largest Value in a Column and Return the Adjacent Cell Value in Excel

Excel Examples

April 16, 2023
Convert State Names To Abbreviations

Excel Examples

April 15, 2023
How To Align Duplicate Values within Two Columns in Excel

Excel Examples, Excel VBA

April 10, 2023
How to Look Up the Lowest Value in A List by VLOOKUP/INDEX/MATCH Functions in Excel

Excel Examples, Excel VBA

April 2, 2023
How to Lookup the Next Largest Value

Excel Examples, Excel VBA

March 29, 2023
How to get nth Match with One Criteria using INDEX/MATCH

Excel Examples

March 27, 2023
How to Find the Last or First Value in a Range Greater Than X in Excel

Excel Examples

March 22, 2023
How to Extract the Column Header of the Largest Value in a Row in Excel

Excel Examples

March 1, 2023