Search results 68

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

Card image cap
Export2CSV

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

Card image cap
CreateUniqueList

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

Card image cap
DynamicFill

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

Card image cap
SaveAsHTML_Template

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

Card image cap
COUNTIFS as Rank

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

Card image cap
IsError_Range

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

Card image cap
RowList_Matching

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

Card image cap
GetColumnIndex

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

Card image cap
Subtotal_Indirects

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

Card image cap
Highlight row of current month

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