I have static data in a spreadsheet column that repeats so I only want
to show the first occurrence of the repeating data in the column. I'm
looking for a way to do this (macro, formula, conditional formatting).
Example: Column COL1 (below) has repeating data in it. I want the
spreadsheet to show just the first BLVD#4 and the first BLVD#8 with
blanks/spaces for teh repeating data.
================================
COL1

BLVD #4
BLVD #4
BLVD #4
BLVD #8
BLVD #8
BLVD #8
BLVD #8
R. MELENDEZ

Should instead be like this:

COL1

BLVD #4


BLVD #8



R.MELENDEZ