How to supress duplicates?

[Guest]

eg if i have

col1 col2 col3 col4
1 2 3 4
1 2 3 6
1 2 3 5
7 8 9 10
i want
1 2 3 4
6
5
7 8 9 10

how do i do this???

mike

 

[Tom Ogilvy]

Use a pivot table under the Data menu would get close.

 

[Dave Peterson]

If you just want to hide the duplicates, maybe you could use format|conditional
formatting.

http://www.contextures.com/xlCondFormat03.html#Duplicate
From Debra Dalgleish's site.

 

[Biff]

If you want a second table:

Assuming the original is in column A to column D, starting in A1:

=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

Copy across to 4 columns then down as needed.

Biff

 

[Guest]

That does work but what if in a column the same number repeats?
as in column 3 the last 3 will be blank?

1 2 3 4
1 2 3 6
1 2 3 5
7 8 9 6
7 8 3 7

 

[Guest]

more info please????

If you just want to hide the duplicates, maybe you could use format|conditional
formatting.

http://www.contextures.com/xlCondFormat03.html#Duplicate
From Debra Dalgleish's site.

 

[Biff]

That does work but what if in a column the same number repeats?

as in column 3 the last 3 will be blank?

Isn't that what you wanted? The last 3 is a dupe so it will be "suppressed".
In fact, based on this last example, the entire last row will be suppressed.

Biff

 

[Dave Peterson]

Did you read the link?

more info please????