ANmarAmdeen

  2. Programmers
  3. ANmarAmdeen
Card image
CountRowCells

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

Jun22
Card image
CalculateQuarterText

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

Jun10
Card image
Q_NoOfdays

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

Jun9
Card image
JSON_To_Table

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

Jun6
Card image
CutString97

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

Jun5
Card image
Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5
Card image
ANmAdd_ThenSort_2Columns

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

Jun1
Card image
MatchIf6Up

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

May31
Card image
MatchIf6

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

May31
Card image
Microsoft Edge gestures

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

May27
Card image
MatchIf5Up

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

May27
Card image
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27
Card image
ANmaHTMLTables_Combine2

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

May16
Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1
Card image
Files_FoundHours

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

Apr30
12...7...7475