Random codes

Similar codes

SortArea1

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

2018Jul4

ANmarAmdeen

SortArea3

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

2018Jul4

ANmarAmdeen

SortArea4

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

Apr15

ANmarAmdeen

Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4

ANmarAmdeen

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

ANmarAmdeen

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

ANmarAmdeen

Column1Range

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

Oct7

ANmarAmdeen

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

ANmarAmdeen

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

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

May1

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

ImagesIn

Just like FilesIn function, but this one returns list of images only found in a ...

2018Nov24

ANmarAmdeen

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31

ANmarAmdeen

ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

ANmarAmdeen

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

ANmarAmdeen