Search results 28

Card image cap
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Card image cap
Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

Card image cap
XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Card image cap
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

Card image cap
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

Card image cap
IsError_Range

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

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

Card image cap
SumOf_3Filters

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

Card image cap
ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Card image cap
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench