Hide cell


Posted by mike on February 08, 2002 7:48 AM

I am trying to create a template where y=the data is formated similar to a group sort display.
eg
1 a
1 b
1 c
2 a
2 b
2 c

formated to
1 a
b
c
2 a
b
c

I am currently doing this by If(a2=a1,"",a2)
in which case I lose the value that was origionally there. Is there a hide cell command that could be used? Eg If(a2=a1,do not display,display)?

regard
Mike



Posted by John on February 08, 2002 8:33 AM

You could use conditional formating. For A1=A2 set the font color to match the backround color of your cells. That wouldmake it disappear.