suppressing repeated data

D

Dina

I have several data bases that I maintain in Access, then export into Excel for printing. This is because I want to use the convenient "fit to one page" function in Excel, instead of spending hours trying to format an Access report. (I want lots of data on one page!) I also want to be able to share electronic files (e.g. club directories) with people who have Excel but not Access.

So here's my problem

Suppose I have a phone list with info like the following

Last Name First Name Phone Type Phone Numbe

Brown Joe home 555-432
Brown Joe beach 333-123
Jones Jane cell 222-222
Jones Jane fax 222-111
Smith John home 555-666
Smith John work 555-999
Smith John cell 444-432

How can I get Excel to only print the first occurrence of "Last Name" and "First Name"? I don't care whether the phone information starts on the same line as the the first occurrence, or on the line below. That is, either of these formats is okay

Brown Joe home 555-432
beach 333-123
Jones Jane cell 222-222
fax 222-111

O

Brown Joe
home 555-432
beach 333-123
Jones Jane
cell 222-222
fax 222-111

Thanks in advance for any help!

Din
 
J

Jordon

You won't be able to suppress printing of duplicates but you
could use conditional formatting that tells it to change the
font color to white if the cell above it is the same.

Jordon

I have several data bases that I maintain in Access, then export
into Excel for printing. This is because I want to use the convenient
"fit to one page" function in Excel, instead of spending hours trying
to format an Access report. (I want lots of data on one page!) I also
want to be able to share electronic files (e.g. club directories) with
people who have Excel but not Access.

So here's my problem:

Suppose I have a phone list with info like the following:

Last Name First Name Phone Type Phone Number

Brown Joe home 555-4321
Brown Joe beach 333-1234
Jones Jane cell 222-2222
Jones Jane fax 222-1111
Smith John home 555-6666
Smith John work 555-9999
Smith John cell 444-4321

How can I get Excel to only print the first occurrence of "Last Name"
and "First Name"? I don't care whether the phone information starts
on the same line as the the first occurrence, or on the line below.
That is, either of these formats is okay:

Brown Joe home 555-4321
beach 333-1234
Jones Jane cell 222-2222
fax 222-1111

OR

Brown Joe
home 555-4321
333-1234
Jones Jane
cell 222-2222
fax
222-1111
 
B

Bob Phillips

Dina,

Use conditional formatting.

Select all of the cells in columns A & B, except row 1, and start the
selection from A2
menu Format>Conditional Formatting
Condition 1 becomes FormulaIs
Click the Format button
Change the font colour to white
OK
OK

And the second (and third if applicable) occurrence are hidden.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Dina said:
I have several data bases that I maintain in Access, then export into
Excel for printing. This is because I want to use the convenient "fit to
one page" function in Excel, instead of spending hours trying to format an
Access report. (I want lots of data on one page!) I also want to be able
to share electronic files (e.g. club directories) with people who have Excel
but not Access.
So here's my problem:

Suppose I have a phone list with info like the following:

Last Name First Name Phone Type Phone Number

Brown Joe home 555-4321
Brown Joe beach 333-1234
Jones Jane cell 222-2222
Jones Jane fax 222-1111
Smith John home 555-6666
Smith John work 555-9999
Smith John cell 444-4321

How can I get Excel to only print the first occurrence of "Last Name" and
"First Name"? I don't care whether the phone information starts on the same
line as the the first occurrence, or on the line below. That is, either of
these formats is okay:
 

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