View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BeckyB BeckyB is offline
external usenet poster
 
Posts: 16
Default Conditional format Formula -Duplicate & n/a

I am trying to do a conditional format formula to highlight duplicate
results, but I have #n/a on some. Is there a way to write the formula to find
all duplicates in 1 column, but ignore all #n/a values too?

Thanks,
BeckyB