Control breaks in Excel

[GKW in GA]

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]

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]

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]

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.