IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...