Excel 2007 : how to add a duplicate condition to if formula

[srollins13]

im using this formula:

=IF(F2="","",IF(ISNA(VLOOKUP(F2,$A$2:$A$999,1,FALSE)),"NOT FOUND","GOOD"))

how do i make it check the entire colum above for duplicates in addition to what is already being done? i am going to drag the formula all the way down to row 1200.

[darkyam]

I'm confused. Do you mean check column F? If so, this formula, beginning in row 3 could be =IF(F2="","",IF(OR(COUNTIF($F$2:$F2,F3),Countif($A$2:$A$999,F3)=0),"NOT FOUND","GOOD"))

[martindwilson]

=IF(AND(A2=$F$2,COUNTIF(A:A,$F$2)>1),"good with duplicate",IF(AND(A2=$F$2,COUNTIF(A:A,$F$2)=1),"good one only","not found"))

[srollins13]

here is a sample of what i need. please see attachment.
as you can see, i am trying to "flag" a duplicate entry and have a formula say "duplicate". thank you for all your help.

[martindwilson]

its not clear what column are you checking?
but if you want to compare col f against col a
=IF(COUNTIF(A:A,F2)>1,"good with duplicate",IF(COUNTIF(A:A,F2)=1,"good one only","not found"))
dragged down

[srollins13]

i am trying to compare a cell in column f against the data entered in the rows above in column f for a duplicate and against column a for a match. If data in cell f22 matches an entry in column "a", a result of "good" is returned, if no match is found then "not found" is returned. At the same time i need cell f22 to compare data in the rows above against the entire column f for a duplicate. The formula I have does what i need but check column f for duplicates. The previous returns are acceptable, but i would like to have a "duplicate" return as well.

[ratcat]

G'day All,

Does this work for you Rollins ?

Please Login or Register  to view this content.

Cheers

RC

[srollins13]

you are so awesome! thank you so much