Search results 31

Sorted from new to old.

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

PivotTable_ShowHideBlankItems

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

2024Jan22

Frequency1

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

2023Dec16

XMLRead

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

2023Nov26

Column1Range

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

2023Oct7

Luhn

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

2023Jul25

ANmAdvancedFilter

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

2022Sep15

IsError_Range

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

2021Dec30

Subtotal_Indirects

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

2021Nov26

Highlight row of current month

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

2021Sep2

SumOf_3Filters

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

2021Jan29

ToolPath

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

2021Jan12

all_tab_columns

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

2019Dec22

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

1 2