Search results 566

Sorted from new to old.

CalculateQuarterText

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

Jun10

Q_NoOfdays

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

Jun9

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

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

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

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

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

MatchIf2Up

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

Apr29

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

1 2 ...5 ...35 36