#N/A

  • Thread starter Thread starter Richie
  • Start date Start date
R

Richie

Hello everyone..Can someone tell the answer to the
following:
I use this formula,=IF(MATCH(C1,C$1:C$3000,0)<ROW
(C1),"Duplicate!","")in column F, to catch duplicates. I
have 1 column with 2300 titles in it. The cells in Col. F
from row 2300 to 3000 have #N/A in them obviously because
I have nothing in the C column. Those cells in column C
will eventually have data in them but in the meantime is
there something I can add to the formula to prevent #N/A
from appearing? Thanks again for the help you've provided
before on other matters.
 
-----Original Message-----
Richie,

A simple test does it

=IF(ISNA(MATCH(C1,C$1:C$3000,0)<ROW(C1)),"",IF(MATCH (C1,C$1:C$3000,0)<ROW(C1
),"Duplicate!",""))

If you want to test for a more general error than #NA change the ISNA to
ISERROR.
--

HTH

Bob Phillips




.
Thank you
Click to expand...
 
Back
Top