Similar codes

Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Card image cap
SortArea1

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

2018Jul4

Card image cap
CountDuplicates

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

2020Oct31

Card image cap
CopyFormat

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

2018Aug10

Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Oct7

Card image cap
SortArea5

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

2018Jul5

Card image cap
SortArea3

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

2018Jul4

Card image cap
RangeValues

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

Jan25

Card image cap
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

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

Apr30

Card image cap
MatchIf2Up

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

Apr29

Random Codes

Card image cap
FindSheet

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

2018Jun7

Card image cap
CutString3

Cuts string from a larger one based on a specific separator.

2018May29

Card image cap
ANmaHTMLTemplate

Index.html template having headers with Bootstrap v4.1 and Font-Awesome (BS4.1 ...

2018May22

Card image cap
Directory Viewer

This is a directory viewer. You can set what files to be viewed. Has ...

2018Apr15