Sorting Problem

Hello,

I have two different worksheets. One worksheet (Sheet 1) has columns A through D filled with different labels that are all correctly matched with each other. Column E is filled with a bunch of dates. The problem is the rows for columns A through D aren't sorted to match with the correct dates.

The other worksheet (Sheet 2) has Sheet 1's column A and E matched correctly. What I need is for Sheet 1's rows to match Sheet 2's rows based on the indexing of Column A in Sheet 2. Help would be greatly appreciated. Thanks!

Solved this!

Use the match function.

I needed 1. Figured it out! The key was the MATCH function.

I selected a column next to the range which needed to be resorted (Sheet1 A:D) and entered

=MATCH(B1, O:O, FALSE)

B1: the indexing key

O: the indexing key but in the correct order

I autofilled this formula down the entire range to get the correct indexing, and then resorted based on the new index. My date column was not part of this range, because it was already in the correct order.


Thanks for your help!

Thanks for sharing your solution. Please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."