Hi Roger,
I used your suggested formular and it really work very well.

Many thanks,
Wilchong

Roger Govier wrote:
Hi

Try
=IF(COUNTIF(A1:C1,A1)1,A1,"-")

Dear T. Valko,
Thanks for your advice. I have studied your formula carefully. Your
[quoted text clipped - 26 lines]
I hope you can advice me on this. Many thanks,
Wilchong

--
Message posted via http://www.officekb.com