Posted to microsoft.public.excel.worksheet.functions
|
|
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
|