View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Radiorick Radiorick is offline
external usenet poster
 
Posts: 2
Default Duplicate entries

Thanks . . . I used your idea and got found all the duplicates, Rick

MyVeryOwnSelf" wrote in message
...
try to use an auxiliar column and concatenate A and B figures =a2&b2
and sort for this one


For the extra picky, maybe something like
=a2&"x"&b2
would work better.

After all, "1" &"12" is the same as "11"&"2".

Never mind if there's enough punctuation in the columns to avoid the
ambiguity.