MyDev

Search results 86

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Finds a name in a workbook, returns true or false

2018Jun10

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

Returns 1 if an item found in array, 0 if not

2018Jun6

Reading QueryString from JS

2018May29

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Finds out if a file exists, can pass either mapped file path, or unmapped

2018Apr25