Search results 473

Sorted from new to old.

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Jul26

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Jul18

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

Jul15

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Jul13

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22

CalculateQuarterText

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

Jun10

JSON_To_Table

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

Jun6

CutString97

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

Jun5

ANmAdd_ThenSort_2Columns

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

Jun1

MatchIf6Up

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

May31

MatchIf6

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

May31

MatchIf5Up

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

May27

1 2 3 ...29 30