ANmarAmdeen

Card image
CutString97

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

Card image
Min_No0s

Getting the minimum number from an array excluding zeros.

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
Microsoft Edge gestures

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

Card image
MatchIf5Up

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

Card image
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

Card image
ANmaHTMLTables_Combine2

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

Card image
MatchIF5

Searching for rows having 5 values in 5 columns Like

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
Files_FoundHours

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

Card image
MatchIf2Up

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

Card image
ANString_Location

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

Card image
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Card image
ANmaCellFormat

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