Math 33 Numbers and formulas

Card image cap
CountDuplicates

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

Card image cap
Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

Card image cap
NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

Card image cap
Fraction calulator

Bing gives you a nice quick way to do calculations, now with fraction ...

Card image cap
Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

Card image cap
MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

Card image cap
CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

Card image cap
fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

Card image cap
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

Card image cap
IsBin

Checks if the passed argument is a binary or not

Card image cap
IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...

Card image cap
Hex2Int

Converts hex to Integer