Ordering based on a template

[gledister]

Imagine we have these data-template as below:

reference01
reference07
reference04
reference03
reference10
reference09

we need to order this data below considering the order on the data-template so for example if we have these data:

reference09
reference03
reference07

The end needs to be:
reference07
reference03
reference09

Thanks in advance!

 

[gledister]

*bump*

 

[Jerry Sullivan]

Hi gledister,

You could use an Array Formula. In the example below, enter the formula in C2:C4 and confirm using Ctrl+Shift+Enter.

Excel Workbook
	A	B	C
1	Template (Named Range)	Input	Sorted by Template
2	reference01	reference09	reference07
3	reference07	reference03	reference03
4	reference04	reference07	reference09
5	reference03
6	reference10
7	reference09
Sheet2

Excel 2007

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

Excel Workbook
Name	Refers To
Template	=Sheet2!$A$2:$A$7
Workbook Defined Names

This example assumes you define a name your template range. You can replace "Template" with your range address in the forumula if you prefer.

 

[gledister]

Wow, great, thanks, works great!