View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default I've borrowed this formula for finding duplicates

Hello Max

Excellent.

I thankyou for taking timeout.

Have a nice day.

"Max" wrote:

Try this then in C2, copied down:
=IF(COUNT(A2,C2)<2,"",IF(A2=C2, "dup",""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Steved" wrote:
Hello Max from Steved

Max I'm getting "dup" when no duplicate's

A3 5525 C3 5521

and not getting "dup" when their are duplicates.

A22 5528 C22 5528