"Geoff" wrote...
I need to count unique items in a list of indices for example:
13.1
13.2
13.3
14.1
15.1
16.1
16.2
The answer would be 4 as the only count I need is the outer index.
The indices are compiled as strings and are in named ranges on several
sheets. I am looking for something like:

This could be done in a worksheet cell formula using

=SUMPRODUCT(1/COUNTIF(SomeRange,INT(SomeRange)&"*"))

In VBA, I'd be tempted to cheat and use Evaluate.