You can create custom Excel functions using VBA matching using your criteria. Create custom Excel functions using Macros in Excel & use user-defined functions in Excel.

User defined Functions and Macros VBA Funtions and Macros that can be used in excel to improve the usability of the software. I have use this for work and personal purposes. SumByFontColor () Function ...

A Microsoft Excel Add-in based on Excel-DNA which adds new user-defined functions (e.g. stock quote queries).

We describe extensions to the Excel spreadsheet that integrate user-defined functions into the spreadsheet grid, rather than treating them as a “bolt-on”. Our case study is unusual in that it ...