Math 35 Numbers and formulas

Card image cap
NMRRank_v2021

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

Card image cap
DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

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