Last used row number and cell address, last numeric or text value in column
|
Left Lookup with Vlookup Excel Function
|
Left Lookup with Index, Match and Offset Excel Functions
|
Shade Alternate Rows - Conditional Formatting
|
Count Number of Unique Values in a Range (with Excel Functions)
|
Remove Duplicates or Create a List of Unique Records using Advanced Data Filter
|
Remove Duplicates or Create a List of Unique Records using Excel Formula
|
Remove Duplicates in a range, using "Remove duplicates" button in Data Tools
|
Find 'Smallest', 'Largest', 'K-th Smallest' and 'K-th Largest' Numbers in a Range
|
Excel Date and Time Functions and Formulas
|
Vlookup Multiple Values - Return MULTIPLE corresponding values for ONE Lookup Value
|
Case Sensitive Vlookup in Excel; Finding the 1st, 2nd, nth or last occurrence of the Lookup Value
|