Tricky Excel De-Dupe Problem
Try this:
=IF(SUMPRODUCT(--(SUBSTITUTE($A$1:A1,MID($A$1:A1,FIND("@",$A$1:A1)-12,12),"*")=
SUBSTITUTE(A1,MID(A1,FIND("@",A1)-12,12),"")))=1,A1,"")- Hide quoted text -
- Show quoted text -
Jeeeez - where do you learn this stuff - NASA? ;;)) I'll give it a
try! Thanks
Right here! (in the newsgroup)
|