Outlines

Lenny · May 13th, 2002, 12:10 AM

If you have information in columns that is duplicates, is there any way to only print the first field in the group.
Example:
ColA ColB ColC ColD
1 TAB ADJ 87
1 TAB ADJ 98
1 TAB ADJ 102
1 TAB ADJ lbj
1 TAB ADJ 09
1 TAB MEK bef
1 TAB MEK bvc
1 TAB MEK 87j
1 TAB MEK 34g
1 TAB MEK gf7

What I would like to do is make it where the duplicates aren't shown. For instance if there are 50 rows of the same thing, can I make it appear in row 1 and not show the 1 or TAB all the way down the column to row 50 in the example for colA.

Thanks

[ This Message was edited by: lenny on 2002-05-13 01:28 ]

[ This Message was edited by: Lenny on 2002-05-13 01:30 ]

Brian from Maui · May 13th, 2002, 12:55 AM

Lenny,

Try this thread, not sure if it will help you

http://www.mrexcel.com/board/viewtop...c=6087&forum=2

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 12:10 AM	#1
Lenny New Member Join Date: Apr 2002 Posts: 9	If you have information in columns that is duplicates, is there any way to only print the first field in the group. Example: ColA ColB ColC ColD 1 TAB ADJ 87 1 TAB ADJ 98 1 TAB ADJ 102 1 TAB ADJ lbj 1 TAB ADJ 09 1 TAB MEK bef 1 TAB MEK bvc 1 TAB MEK 87j 1 TAB MEK 34g 1 TAB MEK gf7 What I would like to do is make it where the duplicates aren't shown. For instance if there are 50 rows of the same thing, can I make it appear in row 1 and not show the 1 or TAB all the way down the column to row 50 in the example for colA. Thanks [ This Message was edited by: lenny on 2002-05-13 01:28 ] [ This Message was edited by: Lenny on 2002-05-13 01:30 ]

May 13th, 2002, 12:55 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Lenny, Try this thread, not sure if it will help you http://www.mrexcel.com/board/viewtop...c=6087&forum=2