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
|