Recent codes added Codes added recently by our developers. 16 most recent codes.

Card image cap
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Mon 1PM
Card image cap
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Sun 7AM
Card image cap
JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6
Card image cap
CutString97

Cuts part from large string from certain character to certain character with ...

Jun5
Card image cap
Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5
Card image cap
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1
Card image cap
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31
Card image cap
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31
Card image cap
Microsoft Edge gestures

Microsoft Edge Right-mouse gestures I found that will really save me time ...

May27
Card image cap
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27
Card image cap
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27
Card image cap
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

May16
Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6
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