Codes Required
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
HMatchIf_Multi
Returns column if an item from list of items was found in a row. Similar to ...
Oct30
MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
Similar codes
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
TextPercentageMatch
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Fancybox iframe
This is to demonstrate how to call a Fancybox from inside an iframe into parent ...
2019Jan15
ANmaHTMLTemplate
Index.html template having headers with Bootstrap v4.1 and Font-Awesome (BS4.1 ...
2018May22