Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.

This example demonstrates how to use the Excel Export library to generate a simple spreadsheet document in code. After running this example, a console application creates an XLSX file and opens it in ...

In this video, you’ll learn how to sort names by last name in Excel, even when first and last names are in the same cell. We ...

Custom pharmacy functions enabling a user to calculate patient metrics, lab values, and drug dosing. With the Pharmacy Function Library, you can perform commonly used clinical pharmacy calculations.