your are required to elaborate your problem, which values you want to
identify?

robo7084 Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=557971