CAn IF compare two cells?

KevinS · External Since: Jun 26, 2009 Posts: 1

I would like to compare cell C3 to C2. If C3 is the same as C2 then mark it
as DUP else goto next line and repeat the action. Compare C4 to C3, etc.

--
Is it the times or the Zeitgiest?

Mike H · External Since: May 24, 2006 Posts: 1059

Hi,

Out this in D3 and drag down as far as required

=IF(C3=C2,"DUP","")

Mike

"KevinS" wrote:

> I would like to compare cell C3 to C2. If C3 is the same as C2 then mark it
> as DUP else goto next line and repeat the action. Compare C4 to C3, etc.
>
>
> --
> Is it the times or the Zeitgiest?