Thanks Biff

However how to I copy it through 7000 lines without cutting and pasting it and not dragging it down, because although it changes the cell reference automatically (required) it also moves the reverence column down one cell each time, (not required) the column reference is the same set of cells for the whole 7000 reference cells.

thanks





T. Valko wrote:

One way...
13-Nov-09

One way...

=IF(COUNT(MATCH(X1,Y:Y,0)),"Yes","No")

Copy down as needed

--
Biff
Microsoft Excel MVP


<Kevin Rudd wrote in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Professional ASP.NET Web Services [Wrox]
http://www.eggheadcafe.com/tutorials...spnet-web.aspx