Search results 107

Sorted from new to old.

VBInstr (or Instr parameters)

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

2019Jan9

Bootstrap table by wenzhixin

Working jquery bootstrap table, with pagination, search, sort and column ...

2018Dec29

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

2018Aug10

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

2018Aug10

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

2018Jul19

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

SettingRead_JR

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

2018Jun26

CellRead (SimpleLookup)

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

2018Jun25

MatchIf_ThenDelete

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

2018Jun17

Match4

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

2018Jun16

Match3

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

2018Jun16

Match2

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

2018Jun16

HMatchIf

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

2018Jun16

MatchIf (aka VMatchIf)

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

2018Jun16

ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

1 2 ...6 7