Search results 37

Sorted from new to old.

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

ANString_to_ListSelects

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

2025Mar24

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

2025Mar10

ANmaSum_5IFs

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

2025Jan8

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

ANmaSum_4IFs

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

2024Nov13

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

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 range of cells in column having data where, ignoring header cell and ...

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

RowList_Matching

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

2021Dec27

Subtotal_Indirects

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

2021Nov26

1 2 3