Random codes

Similar codes

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

Jun30

ANmarAmdeen

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

ANmarAmdeen

Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...

2018Apr25

ANmarAmdeen

Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

2019Dec31

ANmarAmdeen

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

ANmarAmdeen

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

ANmarAmdeen

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

ANmarAmdeen

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

ANmarAmdeen

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

ANmarAmdeen

Recently by developer

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

MatchIf2Up

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

Mon 9AM

ANmarAmdeen

ANString_Location

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

Apr23

ANmarAmdeen

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

ANmarAmdeen

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

ANmarAmdeen

DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22

ANmarAmdeen

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

ANmarAmdeen