excel row sorting problem
 

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

excel row sorting problem
 

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

--
Regards,
Tom Ogilvy

"Terry Thomas" wrote in message
...
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