Hi

I have a worksheet containing a range of values (values are in the format
"1.1.i" or "2.a.i")

I want to identify which values are represented in the range of values

Is there a way of creating a list of values from the range ? This way I can
then do a vlookup to identify which values are mssing from the master list

I am using Excel 2002

Regards
Stephen