Match4

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

Match3

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

Match2

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

HMatchIf

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

MatchIf (aka VMatchIf)

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

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

1FileDB.zip

CountColumnCells + CountColumnCells_Criteria

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

GoToInternet

Opens webpage from within Excel, using default browser

SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...