Search results 63

Sorted from new to old.

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

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

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31

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

2018May23

Converts https found in text into anchers < a > Comes with GetHref as bonus ...

2018May13