Codes Required
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
CutString_Words_Left + CutString_Words_Mid
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8
CutString1
Cuts a string from a string starting from a specific character index and until ...
2018Jul11
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
RowList_Matching
Returns list of rows numbers having cells matching text in a column. Passing ...
2021Dec27
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
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
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
Select Picker (Bootstrap4)
A nice light Bootstrap 4 select drop-down with search capability.
From
2019Jun20
DownloadFile_User
Downloads file to user, asking user where to save or to open downloaded file
2018Jun30