Thank you Mr Norman for helping me with the sumproduct function.

Please I would like any one to help me on how to use ISLIKE formular t
make a search for likely names in my list.
I have tried ISLIKE(text,pattern) and it did not work

--
Message posted from http://www.ExcelForum.com