Search results 90

Sorted from new to old.
Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

Card image
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

Card image
Card5-BS3

Cards in Bootstrap 3, nice and smooth

Card image
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

Card image
SplitTo2DArray

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

Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Card image
SortArea5

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

Card image
SortArea3

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

Card image
SortArea1

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

Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image
RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Card image
Match3

Matching three values at the same time in three columns Just like Match the ...