Codes Required

Card image cap
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Similar codes

Card image cap
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Card image cap
ANStrList functions

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

2018Apr14

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Card image cap
ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

Card image cap
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Dec19

Card image cap
FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

Card image cap
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Random Codes

Card image cap
Paste into textbox

Paste text from clipboard into textbox

2020Oct11

Card image cap
Numeric Input Spinner

A nice Bootstrap 4 numeric spinner used on Input box Originally from

2020Sep17

Card image cap
ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14