Tricky Sorting Question

**wilson32294** · 05-19-2011, 12:05 PM

I have attached a sample excel file.

I am looking to sort column 2 to match column 1, if possible. Do I need a macro? VLOOKUP seems to work to show duplicates but I would like something to actually move and sort the colors to match each other.

I have other data that is very large. This is just a small example.

Thank you for any and all help!!

**martindwilson** · 05-19-2011, 01:32 PM

http://www.excelforum.com/excel-gene...h-another.html

**arthurbr** · 05-19-2011, 02:47 PM

Wilson,

please do not add unnecessary polls to the forum-Thx

**arthurbr** · 05-19-2011, 02:48 PM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.