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?