GitHub

Array functions for VBA

Notifications You must be signed in to change notification settings This Module is a list of functions that I use to make working with arrays in VBA easier. I will continue to add more functions to ...
GitHub

Excel VBA module with functions for (VBA) arrays.

This is essentially a rewrite of Charles H. Pearson’s http://www.cpearson.com/excel/vbaarrays.htm. Thank you for the great work! This repository exists to bundle ...
TechRepublic

Use an Excel array function to create an AverageIf function

Use an Excel array function to create an AverageIf function Your email has been sent Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has ...
TechRepublic

How to use the UNIQUE() function to return a count of unique values in Excel

How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...