Suppress repeating cell values in Excel 1

[klm2klm2]

Does anybody know of a way to suppress repeating values in Excel? Note: I don't want to change the actual values in the cells. I just want to suppress repeating values in specified columns from displaying. In the following example, all cells actually have data values. Repeating values in columns A and B are being suppressed. (Sorry if the columns don't line up in the example. I don't know how to specify a font here.)

A B C
-----------------------------------------------
1 Johnson Foyer Refinish floor
2 Kitchen Refinish floor
3 Tighten microwave trim kit
4 Pantry Install coat hooks
5 Wilson Garage Patch cracked concrete
6 Paint around door
7 Porch Paint around door
8 Clean windows
----------------------------------------------------

Thanks!

 

[GlennUK]

You could do a simple conditional formatting to change the font colour to white in places where entries are supppressed when repeated.

To do this, select A2 to B8, and do menu command Format/Conditional Formatting, and select
Formula Is for the condition, and enter this formula ...
=A2=A1
and click the Format button, and choose a font colour of white. Press OK for the Format and OK for Condtion Formatting for it to be applied.

Glenn.

 

[Zathras]

You can use conditional formatting.

Select all of the cells for which you need to have repeating values not showing, starting with the first cell to be suppressed, which is the same as the second row in the list. (E.g. if Johnson Foyer Refinish floor is in row 1, begin selecting with row 2.) You can select both columns at the same time. For example select A2 thru B1000.

Select Format/Conditional Formatting... from the menu.

Change the condition type from "Cell Value Is" to "Formula Is"

Enter the formula =(A2=A1) This example is for the case where the first cell selected was A2

Click the Format... button

Select Color: (middle of the dialog box) and pick White.

Click Ok twice and check out the results.