excel row sorting problem

[Terry Thomas]

hI

I have got some information laid out like follows

col1 col2 col3 col4
1 name 1 ytr ytr
1 name 1 ytr ytr
1 name 1 ytr ytr
2 name 2 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr
3 name 3 ytr ytr
3 name 3 ytr ytr

i need to get it like this -

col1 col2 col3 col4
1 name 1 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr
1 name 1 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr
1 name 1 ytr ytr
3 name 3 ytr ytr

another approach would be ok to make it so there are no
duplicates in line 1 but it must only be in line 1
therefor the above list would go like

col1 col2 col3 col4
1 name 1 ytr ytr
2 name 2 ytr ytr
3 name 3 ytr ytr

thanks - I hope you get what i mean

ann

 

[Tom Ogilvy]

in column 5 put in a formula like (note the location of the $)

D1: =Countif($A$1:A1,A1)

then drag fill down column 5

Then sort the data on column 5