i have a list of names in one worksheet, i used a countif formula to
count the number of names - but how do i replace the zero when a data
is not found to somethin else such as 'error' or 'not found'??

hope someone can help


--
hsb101
------------------------------------------------------------------------
hsb101's Profile: http://www.excelforum.com/member.php...o&userid=37049
View this thread: http://www.excelforum.com/showthread...hreadid=567749