Control breaks in Excel
 

I have an spreadsheet that has customer information like cust#, customer
name, customer address, pmt date and pmt amt. I want to display the customer
information in customer# order and have the cust#, customer name, customer
address appear only on the 1st row of each customer while the pmt amt and pmt
date are populated on each line.

In other words, I only want to display cust#, customer name, customer
address when there is a break on cust#. How can I do this

Control breaks in Excel
 

First, I would remove those values. You'll be able to do lots more if you have
all the information on each row/record.

But you could hide the duplicates using the technique on Debra Dalgleish's site:
http://contextures.com/xlCondFormat03.html#Duplicate

GKW in GA wrote:

I have an spreadsheet that has customer information like cust#, customer
name, customer address, pmt date and pmt amt. I want to display the customer
information in customer# order and have the cust#, customer name, customer
address appear only on the 1st row of each customer while the pmt amt and pmt
date are populated on each line.

In other words, I only want to display cust#, customer name, customer
address when there is a break on cust#. How can I do this

--

Dave Peterson

Control breaks in Excel
 

Debra's method does what I need. Her example only hides one column, though.
How would I modify it to hide more than 1 column of subsequent repeating rows

"Dave Peterson" wrote:

First, I would remove those values. You'll be able to do lots more if you have
all the information on each row/record.

But you could hide the duplicates using the technique on Debra Dalgleish's site:
http://contextures.com/xlCondFormat03.html#Duplicate

GKW in GA wrote:

I have an spreadsheet that has customer information like cust#, customer
name, customer address, pmt date and pmt amt. I want to display the customer
information in customer# order and have the cust#, customer name, customer
address appear only on the 1st row of each customer while the pmt amt and pmt
date are populated on each line.

In other words, I only want to display cust#, customer name, customer
address when there is a break on cust#. How can I do this

--

Dave Peterson

Control breaks in Excel
 

Her example only shows how to do that format|Conditional formatting to one
column. But you can apply those same techniques to as many columns as you want.

Just select the (next) column and use the column letter in your formula rules.

GKW in GA wrote:

Debra's method does what I need. Her example only hides one column, though.
How would I modify it to hide more than 1 column of subsequent repeating rows

"Dave Peterson" wrote:

First, I would remove those values. You'll be able to do lots more if you have
all the information on each row/record.

But you could hide the duplicates using the technique on Debra Dalgleish's site:
http://contextures.com/xlCondFormat03.html#Duplicate

GKW in GA wrote:

I have an spreadsheet that has customer information like cust#, customer
name, customer address, pmt date and pmt amt. I want to display the customer
information in customer# order and have the cust#, customer name, customer
address appear only on the 1st row of each customer while the pmt amt and pmt
date are populated on each line.

In other words, I only want to display cust#, customer name, customer
address when there is a break on cust#. How can I do this

--

Dave Peterson


--

Dave Peterson