How do I suppress repeated values in Excel 2003

J

Julie

I need to suppress repeated values in a work sheet. I
want Column 1 to only display the value if it has changed
for the next row.
 
F

Frank Kabel

Hi Julie
one way to HIDE these entries:
- If your values are in column A, select the cells starting in the
second data row (e.g. A2) to the last row
- goto conditional format and enter the following formula:
=A2=A1
- choose a white font color for this condition

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Suppression 1
convert repeated sheet 1 names to once in sheet2 1
repeated value 8
HOW DO I COLLECT TEXT DATA FROM A COLUMN 2
Suppress automatic formula creation? 2
suppress printing a repeating value in a column 1
How can I suppress the enable macros and save changes messages? 4
display repeating row information in columns 1

Top