# Monthly Archives: March 2013

## MaxNErr(TheRange)

MaxNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I tend to use controlled errors in my formulas.  As such, since I want to be able to ignore … Continue reading

Posted in Articles, ddGlobal, Puzzles | Tagged , | Leave a comment

## SumNErr(TheRange)

SumNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I tend to use controlled errors in my formulas.  As such, since I want to be able to ignore … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## ddAverage(TheRange,Optional=Exclude)

ddAverage is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This function allows you to exclude specific numbers from your calculation. Assume you are given 100 accounts with a score assigned to it, but you … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## AvgNErr(TheRange)

AvgNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I actually love to have controlled errors in my formulas (especially the #N/A error) as there is a hidden … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## ABSSum(TheRange)

ABSSum is a function within ddGlobal and forms part of the Func_Numeric suite of macros.  ABSSum, or “absolute sum” will convert any negative number into a positive number and add that.  I wrote this function over a decade ago and … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## DDay(StartDay,EndDay)

DDay is a function within ddGlobal and forms part of the ddDate suite of macros.  It is use to calculate the “Difference” between two dates that is in the numeric format YYYYMMDD.  It assumes there is only 360 days in … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## ddInTCK(Startdate,EndDate)

ddInTCK is a function within ddGlobal and forms part of the ddDate suite of macros.  It is based on the famous, or infamous (depending on your point of view), SAS function called InTCK It will basically take two dates that … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## BuildCurDate()

BuildCurDate is a function within ddGlobal and forms part of the ddDate suite of macros.  The macro is straight forward and will use the current date (today), using the excel formula +now() and convert it into the text format YYYY-MM. … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## ConvertDate(ActiveDate, Optional IsFromSas)

ConvertDate is a function within ddGlobal and forms part of the ddDate suite of macros.  It is used to convert various formats of dates into the text format YYYY-MM.  Excel dates counts the days from January 01, 1900 up words.  … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

## ConvertToDays(ActiveDate)

ConvertToDays is a function within ddGlobal and forms part of the ddDate suite of macros.  It is used to calculate the number of days that there is in the text value “YYYY-MM” from.  This has limited use in Excel but … Continue reading

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment