Find Last Used Row in a Column: Related Links: VBA Codes – Last used row; Last used column. ——————————————————————————————————— Formula for ‘Cell Address of the last numeric value within column’ =ADDRESS(MATCH(9.99999999999999E+307, A:A), COLUMN(A1)) [Formula] The formula returns cell address of the last numeric value in column, which is...
Category: Excel Tips
Left Lookup with Vlookup Excel Function
VLOOKUP formula that looks Left instead of Right Related Links: 1. Excel VLOOKP Function, with examples. 2. Left Lookup, with Index, Match & Offset Excel functions 3. Vlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup Value. 4. Case Sensitive Vlookup; Finding the 1st, 2nd, nth or last occurrence of the...
Left Lookup with Index, Match and Offset Excel Functions
Left Lookup with Index, Match and Offset Excel Functions Related Links: 1. Excel VLOOKP Function, with examples. 2. Left Lookup with VLookup Excel function 3. Vlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup Value. 4. Case Sensitive Vlookup; Finding the 1st, 2nd, nth or last occurrence of the Lookup Value....
Shade Alternate Rows – Conditional Formatting
Shade Alternate Rows using Conditional Formatting —————————————————————————————————————————- Shade Alternate Rows, including blank/unused range Select worksheet range you wish to format Home -> Conditional Formatting -> New Rule -> select “Use a formula to determine which cells to format” option (Excel 2007) Format -> Conditional Formatting -> “Formula Is” (earlier...
Count Number of Unique Values in a Range (with Excel Functions)
Related Links: 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 ————————————————————————————————————————— Count Number of Unique Values (when No Blank Cells), with Excel Functions: ...
Remove Duplicates or Create a List of Unique Records using Advanced Data Filter
Related Links: Count Number of Unique Values, with Excel Functions Remove Duplicates or Create a List of Unique Records using Excel Formula Remove Duplicates in a range, using “Remove duplicates” button in Data Tools Create a List of Unique Records Using Advanced Data Filter: ——————————————————————————————————– Using Advanced Data Filter Select a...
Remove Duplicates or Create a List of Unique Records using Excel Formula
Related Links: Count Number of Unique Values, with Excel Functions Remove Duplicates or Create a List of Unique Records Using Advanced Data Filter Remove Duplicates in a range, using “Remove duplicates” button in Data Tools ————————————————————————————————————————– Remove Duplicates or Create a List of Unique Records in Excel Create a List of...
Remove Duplicates in a range, using “Remove duplicates” button in Data Tools
Related Links: Count Number of Unique Values, 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 the top menu tab Data -> Data...
Find ‘Smallest’, ‘Largest’, ‘K-th Smallest’ and ‘K-th Largest’ Numbers in a Range
Find ‘Smallest’, ‘Largest’, ‘K-th Smallest’ and ‘K-th Largest’ Numbers in a Range with Excel Functions Related Links: Remove Duplicates in a range, using “Find Smallest and Largest Value with VBA. Using ParamArray to find Minimum Value. ————————————————————————————————————————— Find Smallest Number or K-th Smallest Number in a Range Find Smallest Number in a Range,...
Excel Date and Time Functions and Formulas
Excel Date and Time Functions & Formulas Excel Dates Equate to Serial Numbers: Excel stores all dates as integers and all times as decimal fractions. With this system, Excel can add, subtract, or compare dates and times just like any other numbers, and all dates are manipulated by using this system....
Vlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup Value
Vlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup Value Related Links: 1. Excel VLOOKP Function, with examples. 2. Left Lookup with VLookup Excel function. 3. Left Lookup, with Index, Match & Offset Excel functions. 4. Case Sensitive Vlookup; Finding the 1st, 2nd, nth or last occurrence of the Lookup Value. Return MULTIPLE...
Case Sensitive Vlookup in Excel; Finding the 1st, 2nd, nth or last occurrence of the Lookup Value
Case Sensitive Vlookup in Excel; Finding the 1st, 2nd, nth or last occurrence of the Lookup Value Related Links: 1. Excel VLOOKP Function, with examples. 2. Left Lookup with VLookup Excel function. 3. Left Lookup, with Index, Match & Offset Excel functions. 4. Vlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup Value....