Counts how many cells matching 2 criterias.
Just like
May1
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
Finds the URL (href tag value) for an anchor inside a table row (tr element) ...
Mar4
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
Test if a character is alphanumeric, regardless of the code page or language ...
2020Mar21
Remove any char (or string) found between two quotes in a string This is an ...
2020Mar9
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
Downloads list of domains and prices for register, renew or transfer into ...
2018May25
Downloads list of registered Domains in your account from NameSilo.com using ...
2018May25
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...
2018Oct1
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...
Aug17
Adds amount to active cell, or subtract Applies to selected cell in current ...
2022Sep1
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7