Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
Control Excel page breaks during sort? | Excel Discussion (Misc queries) | |||
Hard breaks in text to soft breaks in Excel | Excel Discussion (Misc queries) | |||
Axes Breaks with Excel?? | Charts and Charting in Excel | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) |