Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting in Excel 2007 problem | Excel Worksheet Functions | |||
Excel Sorting Problem | Excel Discussion (Misc queries) | |||
excel within row sorting problem | Excel Discussion (Misc queries) | |||
sorting problem in excel 2000 | Excel Discussion (Misc queries) | |||
Problem sorting in Excel | Excel Discussion (Misc queries) |