Hi Bryan,
Thank you for your suggestion. It worked out just great and does what I
want it to do. Thanks so much
Sue

"Bryan Hessey" wrote:


the easy way would be to use a helper column and enter

=IF(B1=0,"ZZZ",B1)

(assuming your name is in B1).

Then sort over the helper column etc (this can be a hidden column if
you wish)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=389531