Re: Check for duplicates

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 23:37:33 -0000

Pat,

I think this is probably what you want

=IF(AND(V304="",ISNUMBER(MATCH("2"&" " &V304& " " &W304& " "
&X304,C7:CF1000,0))),"2"&" " &V304& " " &W304& " " &X304,"") 

-- 
HTH
RP
(remove nothere from the email address if mailing direct)
"Pat" <glass_patrick@hotmail.com> wrote in message
news:%23OabS4HFFHA.1564@TK2MSFTNGP09.phx.gbl...
> Hi Bob,
> V304& " " &W304& " " &X304 is being compared.
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:%23Ow45rHFFHA.3312@TK2MSFTNGP15.phx.gbl...
> > what result is being compared, the spaces, V304, or the concatenated
value
> > (Or any)?
> >
> > -- 
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Pat" <glass_patrick@hotmail.com> wrote in message
> > news:%23qDe3nHFFHA.4004@tk2msftngp13.phx.gbl...
> >>
> >> The following formula is contained in C304
> >>
> >> =IF(V304="","","2"&" " &V304& " " &W304& " " &X304)
> >>
> >> I need to include into the formula a way to check if the result is a
> >> duplicate of another result in column C.
> >> The range covers from C77:C1000.
> >>
> >> Thank you if you can help.
> >> Pat
> >>
> >>
> >
> >
>
>

Relevant Pages