Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

IsError_Range

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

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Subtotal_Indirects

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

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

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, ...