Hi Annie,

What about this countif

=COUNTIF($G$1:G1,G1)
=COUNTIF($G$1:G2,G2)

Format cells in custom as 000 if G3 is blank then "000" will appear so
you can turn off by going to Tools options View and unticking zero
values.
Note the first cell "G1" in this example needs to be a absolute

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553303