Assuming worksheet is sorted by Column A first, then Column B (like you
have in your example)...
enter this in C1 and auto copy down.

=IF(AND($A1=$A2,$B1$B2),"",$B1)


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