Random codes

Similar codes

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmarAmdeen

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

ANmarAmdeen

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

ANmarAmdeen

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

ANmarAmdeen

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

ANmarAmdeen

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ANmarAmdeen

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

ANmarAmdeen

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

ANmarAmdeen

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

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

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

ANmarAmdeen

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

2018Jul19

ANmarAmdeen

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

ANmarAmdeen

URL2Text + Text2URL

URL2Text to convert a URL into string Text2URL will converts a text with ...

2018Apr15

ANmarAmdeen