Function Type: Lookup and Reference Description: Returns a list of unique values in a list or range Function Structure: =UNIQUE(array, [column?], [distinct?]). Argument Breakdown: array – The list array or range to find the unique values from. [column?] – Is it by column? TRUE or FALSE [distinct?] – Do you want the values that appearsContinue reading “UNIQUE Function”
Tag Archives: Excel
SUMPRODUCT Function
Function Type: Math and Trigonometry Description: Returns the sum of the products of corresponding array components. Function Structure: =SUMPRODUCT(array1, [array2], [array3]). Argument Breakdown: array1 – The first array or range to multiply, then add. array2 – The second array or range to multiply, then add. array3 – The third array or range to multiply thenContinue reading “SUMPRODUCT Function”
TRIM function
Function Type: Text Description: Removes spaces from text. Function Structure: =TRIM(text). Argument Breakdown: text – The text from which to remove extra space. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below. We can also accept LEO, HIVE, HBD tokens as payment if we transact directlyContinue reading “TRIM function”
RIGHT, RIGHTB function
Function Type: Text Description: Returns the rightmost characters from a text value. Function Structure: =RIGHT, RIGHTB(text, [num_chars], [num_bytes]). Argument Breakdown: text – The text string containing the characters you want to extract. num_chars – Specifies the number of characters you want RIGHT to extract. num_bytes – Specifies the number of characters you want RIGHTB toContinue reading “RIGHT, RIGHTB function”
LEN, LENB function
Function Type: Text Description: Returns the number of characters in a text string. Function Structure: =LEN, LENB(text). Argument Breakdown: text – The text for which to calculate length. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below. We can also accept LEO, HIVE, HBD tokens asContinue reading “LEN, LENB function”
SUBSTITUTE function
Function Type: Text Description: Substitutes new text for old text in a text string. Function Structure: =SUBSTITUTE(text, old_text, new_text, [instance_num]). Argument Breakdown: text – The text to change. old_text – The text to replace. new_text – The text to replace with. instance_num – The instance to replace. If not supplied, all instances are replaced. Example:Continue reading “SUBSTITUTE function”
FIXED function
Function Type: Text Description: Formats a number as text with a fixed number of decimals. The result will be a text (alphanumeric) type. Function Structure: =FIXED(number, [decimals], [no_commas]). Argument Breakdown: number – The number to round and format. decimals – Number of decimals to use. Default is 2. no_commas – Suppress commas. TRUE = noContinue reading “FIXED function”
COUNTBLANK function
Function Type: Statistical Description: COUNTBLANK function in Excel or Google Sheets counts cells that are blank in a given range of cells specified. Literally just the empty / blank cells. Even a single space bar character or invisible texts (white font on white fill cell) on a cell well not be included in the countContinue reading “COUNTBLANK function”
COUNTA function
Function Type: Statistical Description: COUNTA function in Excel or Google Sheets counts cells that contain anything in a cell or a given range of cells. It counts even the errors, Boolean, AlphaNumerics or even a single space bar character. In my head, Excel or GSheets is counting AlphaNumerics which is short for CountA. Or maybeContinue reading “COUNTA function”