Outlier Correction Quartile VBA

Here is my VBA UDF for Excel that can be used to perform Outlier Correction on a range of values >0 with optional exclude time series periods and fence (very useful to prevent cleaning of seasonal periods). Copy & Paste this Code into any Standard Code Module

Function information is added to the Macro Table in the 'ThisWorkbook' Sheet giving you intellisense about the Named Arguments in the 'fx' (Formula Box) in Excel

Use the UDF like this in any Worksheet in Excel for a range of any size:

Standard UDF call (Known_ys := values, Known_xs := time periods)

=QuartileOutlierCorrection($B8:$BA8,$B$6:$BA$6)

Exclude time periods ($BB$2 is a single cell reference with a comma-delimited list i.e. '3, 21')

=QuartileOutlierCorrection($B8:$BA8,$B$6:$BA$6,$BB$2)