Search results 203

Sorted from new to old.
Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

Card image
Range2ANStr

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

Card image
SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

Card image
ANmaSQL_UpdateDateStatement

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

Card image
Export2CSV

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

Card image
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

Card image
CreateUniqueList

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

Card image
DynamicFill

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

Card image
SaveAsHTML_Template

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

Card image
COUNTIFS as Rank

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

Card image
IsError_Range

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

Card image
RowList_Matching

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

Card image
GetColumnIndex

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

Card image
Subtotal_Indirects

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