VLOOKP Function in Excel (with examples), using Exact and Approximate Matches, Error (#N/A) handling, … Related Links: 1. Left Lookup with VLookup Excel function. 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...
Category: Excel Functions
Excel SUMPRODUCT Function
Using SUMPRODUCT FUNCTION Using double unary minus (–) n SUMPRODUCT Function -> A significant use ———————————————————————————————————————————————————— Excel SUMPRODUCT Function: The SUMPRODUCT function multiplies corresponding items of two or more arrays and then sums up these products. Syntax: SUMPRODUCT(array1, array2, … array255) 1. array1, array2, … array255 are arrays whose...
Excel OFFSET Function
Using the Excel OFFSET Function, with Examples —————————————————————————————————————————— OFFSET Function: The excel OFFSET function returns a range, which is offset by a specified number of rows and columns from a reference range. Syntax: OFFSET(reference_range, rows, columns, height, width) 1. reference_range is a single cell or a range of adjacent cells...
Excel INDIRECT Function
Excel INDIRECT Function, with Examples: —————————————————————————————————————————– Excel INDIRECT Function: The INDIRECT function returns the result of a specified reference. Syntax: INDIRECT(text_reference, reference_type) 1. text_reference is a reference to a cell and that cell can contain: (i) an A1-style reference; (ii) an R1C1-style reference; (iii) a named range; or (iv) a...
Excel IF Function and IF Statements
Excel IF Function and IF Statements, with Examples Related Link: If…Then…Else Statements (VBA). ———————————————————————————————————————— Excel IF Function: The IF function is used to test if a condition is True or False. If a specified condition evaluates to TRUE, the IF function returns one value, and if the condition evaluates to...
CHOOSE Function in Excel
CHOOSE Function in Excel and its uses, make Vlookup Look Left & Find Date of Next Monday with CHOOSE function. Related Links: VLOOKUP formula that looks left instead of right. ————————————————————————————————————————– Excel CHOOSE Function The CHOOSE function returns a value from a list of values based on a specified position number. Syntax: CHOOSE(position_number,...
Excel Text and String Functions: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE
Excel Text and String Functions: Excel Functions for Finding and Replacing Text, with Examples: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE Related Links: 1. Excel Text and String Functions: TRIM & CLEAN. 2. Excel CODE & CHAR functions. ————————————————————————————————————————- This section deals with the Excel Worksheet String Functions – click here for detailed...
Excel Text and String Functions: TRIM & CLEAN
Excel Text and String Functions: Removing spaces and nonprinting characters from text: Excel TRIM & CLEAN functions Related Links: 1. ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code. 2. Excel CODE & CHAR functions. 3. Excel Text and String Functions: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE. When you import data into...
Excel CODE & CHAR Functions, VBA Asc & Chr Functions
Excel Text and String Functions: Excel CODE & CHAR Functions, VBA Asc & Chr Functions, with examples. Related Links: 1. Using VBA Chr and Asc functions to convert excel column number to corresponding column letter, and column letter to column number. 2. ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code. 3. Excel Text...
ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code.
ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code Related Links: 1. VBA Chr & Asc functions explained; corresponding Excel CHAR and CODE functions. 2. Excel Text and String Functions: TRIM & CLEAN. A ‘character set‘ maps characters to their identifying code values. Unicode is a global standard for character encoding and is the...