Suppressing a cell content, which is the same as the above cell

P

Peter

Hi folks,
I have a question regarding group formatting for 2007 Excel. The
sample is as below:
column A column B
John Doe 1 apple
John Doe 1 orange
John Doe 2 apple
John Doe 2 orange
John Doe 2 banaba
John Doe 3 apple
John Doe 3 orange
John Doe 3 banaba
John Doe 3 pine apple
John Doe 3 pears
If I want to suppress the names, which are the same as the above, is
there is a concise way to achieve it. Thanks.
Peter Kao
 
A

Alojz

Do not know about formatting, but 2 other ways exist.
First: Create auxiliary column with formula. Formula for c2: =a2, for cell
c3: =if(a3=a2,"",a3), copy from c3 down to c4:c11. Rearrange columns and hide
column a.
Second option: create pivod table with row labels defined as column a and
column b of ur source table. Make appropriate formatting of pivot table
according ur wishes (not display subtotals etc.).

Click yes if this was helpful.
 
A

Alojz

Found even more easy solution: conditional formatting. Click on cell A3 and
create conditional format via formula: =A3=A2, set range valid for
=$A$3:$A$11, set format: text-blank. Easy!

Click yes if this was helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top