Thanks to cpearson.com I can highlight dups. But I need to combine this with
another condition.
I want to identify dups in Col B only if the dup record contains (column K)
"no record". (Both of the dup records will have this string if either does.)
I've tried Formula =countif ($B$12:$B$928, B12)1 and
Formula =$K12$K$928 =no record
as the conditions. Also tried each as condition 1 and 2 and several
variations of the second formula. The results have been that the dups are
identified but the "No record" condition has no effect as Cond 1 or 2.
Any suggestions would be appreciated.
Thanks,
wal50

How about:
=if(and(countif($b$12:$b$928,b12)1,k12="no record"),"dupe","not a dupe")



wal50 wrote:

Thanks to cpearson.com I can highlight dups. But I need to combine this with
another condition.
I want to identify dups in Col B only if the dup record contains (column K)
"no record". (Both of the dup records will have this string if either does.)
I've tried Formula =countif ($B$12:$B$928, B12)1 and
Formula =$K12$K$928 =no record
as the conditions. Also tried each as condition 1 and 2 and several
variations of the second formula. The results have been that the dups are
identified but the "No record" condition has no effect as Cond 1 or 2.
Any suggestions would be appreciated.
Thanks,
wal50


--

Dave Peterson

Thanks Dave. As always with this site, a quick and accurate reply.
I can use this to format the rows I want.
wal50

"Dave Peterson" wrote:

How about:
=if(and(countif($b$12:$b$928,b12)1,k12="no record"),"dupe","not a dupe")



wal50 wrote:

Thanks to cpearson.com I can highlight dups. But I need to combine this with
another condition.
I want to identify dups in Col B only if the dup record contains (column K)
"no record". (Both of the dup records will have this string if either does.)
I've tried Formula =countif ($B$12:$B$928, B12)1 and
Formula =$K12$K$928 =no record
as the conditions. Also tried each as condition 1 and 2 and several
variations of the second formula. The results have been that the dups are
identified but the "No record" condition has no effect as Cond 1 or 2.
Any suggestions would be appreciated.
Thanks,
wal50


--

Dave Peterson