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

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

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 ...

Apr30

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

Dec21

ANmarAmdeen

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

ANmarAmdeen

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10

ANmarAmdeen

CSSFlowChart

Shows a chart with links, nice sitemap maybe, or just easy way to show ...

2018Aug14

ANmarAmdeen