How do I suppress repeated values in Excel 2003

  • Thread starter Thread starter Julie
  • Start date Start date
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.
 
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
 
Back
Top