Format Repeated Values

  • Thread starter Thread starter OriginalStealth
  • Start date Start date
O

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
 
I wouldn't do this. It really makes sorts miserable later. (As well as other
stuff, too.)

But you could hide the duplicate:

Select A3:Dxxx 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?).
 
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.
 
Back
Top