User Defined Functions (UDFs) for common calculations

User Defined Functions (UDFs) are functions that can be inserted directly into formulas within cells just like SUM, AVG, VLOOKUP and the other built in functions. The difference is that the functions are custom made to your unique calculations.
In this project, we developed a set of User Defined Functions (UDFs) for a client who was constantly using the same formulas over and over again. They used these functions to help convert data from an old legacy system to a different format that matched their new sales system. This allowed them easily merge reports from both systems without having to rewrite the same functions over and over. In the image, you can see the old legacy part numbers in column A and the legacy city in column B. The UDFs we designed converted the format of the part number to look like column C and actually did a lookup of the city to determine the region in column D. If you look closely at rows 5 -7, you can actually see the UDF functions being used in the formulas in column C and D.
See a video demonstration of this project here.