Some database management systems allow the creation of user defined functions in languages other than SQL . Microsoft SQL Server, for example, allows the user to use . NET languages including C # for this purpose.
12.
:If you plan on using this in Excel, I think the easiest method would be to create a user defined function using VBA; you could have it take two ranges of cells; it wouldn't be too difficult to code it to find the correct cells to use.