Search results 19

Sorted from new to old.

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

Luhn

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

2023Jul25

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

Nautical/Flight Functions

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

2020Oct13

Fraction calulator

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

2020Feb1

MinIF and MaxIF in Excel 2010

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

2019Feb1

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

2018Jul25

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

1 2