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

ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

Feb10

ANmarAmdeen

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

Aug13

ANmarAmdeen

Slickmap

CSS only flow chart site map From

2019Aug8

ANmarAmdeen

fotorama 4.6.4

jQuery photo gallery Dont you just love those small simple libraries that do ...

2019Jun27

ANmarAmdeen