Store result from formula array into variable

Hi Vito,

I don't really know how the VBA Evaluate function knows array formulas when they're passed to it (it doesn't need the { } brackets) - but it does!! Try this:

Please Login or Register  to view this content.

You should try and avoid array formulas where possible as they're a big drain on resources. For some other possible formulas to count the number of unique entries see here.

HTH

Robert