View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louja Louja is offline
external usenet poster
 
Posts: 17
Default Finding duplicates

How do I write a formula that looks at two columns and looks for
duplicate values in both, and flags the row if it finds them in?

See below example I would want to look at columns A and B and look for
duplicate values in both columns

A B
123 abc
124 def
125 ghi
126 jkl
126 mno
126 mno
127 pqr