Codes Required

Similar codes

code image
HMatchIf

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

2018Jun16

code image
MatchIf (aka VMatchIf)

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

2018Jun16

code image
RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

code image
Match3

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

2018Jun16

code image
FixPath, IsThere, IsThere1 ...

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

2018Jun11

code image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

code image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

Nov2

code image
Match4

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

2018Jun16

code image
ANStrList functions

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

2018Apr14

Recently by developer

code image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

code image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

code image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

code image
TrimLines

Remove all line breaks from text from a text. Not like

Jan31

Random Codes

code image
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

code image
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

code image
tAutocomplete

Dropdown list for input box works as Autocomplete Multi-column, themeable ...

2019Jun25

code image
Rename File

This will rename a specific file and or move the file to a different directory

2018Apr16