Format Repeated Values

[OriginalStealth]

ID Title Theatre City Date
1234 Matrix AMC Buckhead 1/29/2004
1234 Matrix AMC Buckhead 1/30/2004
1234 Matrix AMC Buckhead 1/31/2004
1222 Matrix2 AMC Jonesboro 1/31/2004

If the ID is the same how can I format the duplicate row to
read:

1234 Matrix AMC Buckhead 1/29/2004
"" "" "" "" 1/30/2004
"" "" "" "" 1/31/2004
1222 Matrix2 AMC Jonesboro 1/31/2004


thanks in advance
OS

 

[Dave Peterson]

I wouldn't do this. It really makes sorts miserable later. (As well as other
stuff, too.)

But you could hide the duplicate:

Select A3xxx and do
format|conditional formatting
choose "Cell Value is" "Equal to" =A2
(remove any $ signs that excel may have added (if you pointed at that cell)

Then format it so the font color matches the fill color (white on white?).

 

[Ken Wright]

Don't do it!!!! If you really must, then dump it all into a Pivot table and
have the Pivot table report the data that way, then you don't lose the detail.