I managed to find duplicates in the list by using the conditional
formatting.

I didn't understand how to find out if a specific value is in a list.

I have a list ranging from A1:D1000 containing numbers.
I want to find out if that list contains the value 878 and 882 and see
where this is in my list.

How can I do this?

Regards, Irene


--
Irene
------------------------------------------------------------------------
Irene's Profile: http://www.excelforum.com/member.php...o&userid=34269
View this thread: http://www.excelforum.com/showthread...hreadid=540974