Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reordering column to match list
Hi,
Im trying to set the order of the list within a column to match that of another list within the worksheet ie. A B C D Swick Northerly Comment about Northerly Forensics Sebring Comment about Sebring Sebring Sunline Comment about Sunline Northerly Forensics Comment about Forensics Sunline Swick Comment about Swick Column A is in correct order whereas column C isn't. Ideally I'm trying to get the contents of column D to correctly match up with each entry in column A so that there is only the list on the left followed by the corresponding comment. I've tried sorting and various other methods without success ... can someone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reordering column to match list
Can I assume that the 'Comment about Northerly' contains the word 'Northerly'
and so on? "Mickoz" wrote: Hi, Im trying to set the order of the list within a column to match that of another list within the worksheet ie. A B C D Swick Northerly Comment about Northerly Forensics Sebring Comment about Sebring Sebring Sunline Comment about Sunline Northerly Forensics Comment about Forensics Sunline Swick Comment about Swick Column A is in correct order whereas column C isn't. Ideally I'm trying to get the contents of column D to correctly match up with each entry in column A so that there is only the list on the left followed by the corresponding comment. I've tried sorting and various other methods without success ... can someone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reordering column to match list
The comment doesn't contain the name, it's always in the cell to the left of
it. "Sheeloo" wrote: Can I assume that the 'Comment about Northerly' contains the word 'Northerly' and so on? "Mickoz" wrote: Hi, Im trying to set the order of the list within a column to match that of another list within the worksheet ie. A B C D Swick Northerly Comment about Northerly Forensics Sebring Comment about Sebring Sebring Sunline Comment about Sunline Northerly Forensics Comment about Forensics Sunline Swick Comment about Swick Column A is in correct order whereas column C isn't. Ideally I'm trying to get the contents of column D to correctly match up with each entry in column A so that there is only the list on the left followed by the corresponding comment. I've tried sorting and various other methods without success ... can someone help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reordering column to match list
In B1 enter
=VLOOKUP(A1,C:D,2,false) and copy down... Once you verify that the you got the right comments in Col B against entries in Col A, Select Col B, Edit-Copy then Edit-Paste Special-Values... You can then delete Col C & D "Mickoz" wrote: The comment doesn't contain the name, it's always in the cell to the left of it. "Sheeloo" wrote: Can I assume that the 'Comment about Northerly' contains the word 'Northerly' and so on? "Mickoz" wrote: Hi, Im trying to set the order of the list within a column to match that of another list within the worksheet ie. A B C D Swick Northerly Comment about Northerly Forensics Sebring Comment about Sebring Sebring Sunline Comment about Sunline Northerly Forensics Comment about Forensics Sunline Swick Comment about Swick Column A is in correct order whereas column C isn't. Ideally I'm trying to get the contents of column D to correctly match up with each entry in column A so that there is only the list on the left followed by the corresponding comment. I've tried sorting and various other methods without success ... can someone help? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reordering column to match list
Woohoo vlookup ... works a treat .... had problems at first try with leading
spaces and (160) spaces hampering the process - once they were gone I was home free - Thank you "Sheeloo" wrote: In B1 enter =VLOOKUP(A1,C:D,2,false) and copy down... Once you verify that the you got the right comments in Col B against entries in Col A, Select Col B, Edit-Copy then Edit-Paste Special-Values... You can then delete Col C & D "Mickoz" wrote: The comment doesn't contain the name, it's always in the cell to the left of it. "Sheeloo" wrote: Can I assume that the 'Comment about Northerly' contains the word 'Northerly' and so on? "Mickoz" wrote: Hi, Im trying to set the order of the list within a column to match that of another list within the worksheet ie. A B C D Swick Northerly Comment about Northerly Forensics Sebring Comment about Sebring Sebring Sunline Comment about Sunline Northerly Forensics Comment about Forensics Sunline Swick Comment about Swick Column A is in correct order whereas column C isn't. Ideally I'm trying to get the contents of column D to correctly match up with each entry in column A so that there is only the list on the left followed by the corresponding comment. I've tried sorting and various other methods without success ... can someone help? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reordering column to match list
Great, thanks. I love VLOOKUP (and SUMPRODUCT)
In this particular case you could have used a simple sort on only Col C & D... you must have tried that but it probably did not work due to 'spaces' "Mickoz" wrote: Woohoo vlookup ... works a treat .... had problems at first try with leading spaces and (160) spaces hampering the process - once they were gone I was home free - Thank you "Sheeloo" wrote: In B1 enter =VLOOKUP(A1,C:D,2,false) and copy down... Once you verify that the you got the right comments in Col B against entries in Col A, Select Col B, Edit-Copy then Edit-Paste Special-Values... You can then delete Col C & D "Mickoz" wrote: The comment doesn't contain the name, it's always in the cell to the left of it. "Sheeloo" wrote: Can I assume that the 'Comment about Northerly' contains the word 'Northerly' and so on? "Mickoz" wrote: Hi, Im trying to set the order of the list within a column to match that of another list within the worksheet ie. A B C D Swick Northerly Comment about Northerly Forensics Sebring Comment about Sebring Sebring Sunline Comment about Sunline Northerly Forensics Comment about Forensics Sunline Swick Comment about Swick Column A is in correct order whereas column C isn't. Ideally I'm trying to get the contents of column D to correctly match up with each entry in column A so that there is only the list on the left followed by the corresponding comment. I've tried sorting and various other methods without success ... can someone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reordering and combining data | Excel Discussion (Misc queries) | |||
Reordering part of a list with VBA | Excel Worksheet Functions | |||
Reordering a List in Numerical Order | Excel Worksheet Functions | |||
match word in one column form list in another | Excel Worksheet Functions | |||
Reordering Bars in Bar Graphs | Charts and Charting in Excel |