Search results 295

Sorted from new to old.
Card image
QuarterNumber_FromDate

Returns the number of quarter from a date

Card image
DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

Card image
ANStr_Add10IfNotBlank_NorNA

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

Card image
IfString_StartsWith_AndOr_EndsWith

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

Card image
ANmaSearch_QuoteFriends

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

Card image
ANmaReplace_Occurrence

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

Card image
ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Card image
ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Card image
CountRowCells

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

Card image
CalculateQuarterText

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

Card image
Q_NoOfdays

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

Card image
CutString97

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

Card image
ANmAdd_ThenSort_2Columns

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

Card image
MatchIf6Up

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

Card image
MatchIf6

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

Card image
MatchIf5Up

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