Hi, this probably is relatively simple, but I can't figure it out. I have a spreadsheet with many columns that I need to sort based on a unique numeric 'keycode', but the sort has to be in the same order as the 'keycode' in another spreadsheet, which is neither ascending or descending. I have to keep them ordered exactly the same in the two spreadsheets. Is there a way to do this without extensive coding? Thanks for any assistance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel sort based on matching columns
- Thread starter yoshe
- Start date
SkipVought
Programmer
Hi,
Method 1: COPY the KeyCode column from the source to this sheet and use the KeyCode LOOKUP the other values in the row.
Method 2: Add a column to your source sheet that is a numeric sequence nbr. It could be as simple as =ROW(). In your sheet of concern, LOOKUP the Sequence nbr for the KeyCode. Sort on THIS NEW COLUMN.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...for a NUANCE!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Thread starter
- #3
SkipVought
Programmer
Actually, you don't even NEED the Seq Nbr column in the original sheet. Just use the MATCH function in a new column on your sheet to sort, and it will return the relative offset (row if you will).
Skip,
[sub]
Just traded in my old subtlety...for a NUANCE!
[/sub]- Status