Random codes

Similar codes

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

ANmarAmdeen

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

ANmarAmdeen

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

ANmarAmdeen

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

ANmarAmdeen

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

ANmarAmdeen

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

ANmarAmdeen

FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

ANmarAmdeen

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

ANmarAmdeen

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

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

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

ANmarAmdeen

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

ANmarAmdeen

CSS3 Progressbar

A progress-bar in pure CSS3, used before we got Bootstrap :-)

2019Jan14

ANmarAmdeen

UTF8R_toChar

Converts characters created by program R into actual chars as in < U+641 > to ...

2018Jun26

ANmarAmdeen