Search results 178

Sorted from new to old.

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

1 2 ...4 ...11 12