How to arrange/reference/find data between 2 lists

**dori2o** · 05-31-2017, 08:47 AM

I have an excel sheet (sheet 1) with column A having a list of Names, and B with a list of ID Numbers

I then have column E showing list of ID numbers (the same ID numbers as in column B but in a different order) and column F with a list of dates which show when the ID number is due for renewal.

I want to arrange the list of the names to be in order of date of renewal.

Any advice?

Much appreciated

**Tsjallie** · 05-31-2017, 09:28 AM

There are two options:

Select the whole range (column A thru F) and sort on column F
Add a helper column (C) to the list of Names and Id's with a lookup of the renewal date based on the ID and then select columns A-C and sort on column C

**dori2o** · 05-31-2017, 11:09 AM

Thanks.

problem solved

How to arrange/reference/find data between 2 lists

LinkBack

Thread Tools

Rate This Thread

Display

How to arrange/reference/find data between 2 lists

Re: How to arrange/reference/find data between 2 lists

Re: How to arrange/reference/find data between 2 lists

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find and highlight differences between two lists where one list is the reference list

Reference external data in drop-down lists

Cross reference 2 lists. Count matches on 2 lists. WHat feature to use?

[SOLVED] Cross Reference Lists to find Duplicates & List Line Item

Using Validation and Lists to reference data

Can Data Validation Lists reference another work book?

Bookmarks

Bookmarks

Posting Permissions