Ordering one table by the rules from another table

**Richard Buttrey** · 08-25-2013, 07:29 PM

Originally Posted by sulin360

Sorry, I missed it completely!

The solution almost works, however the formula produces anomalies when it deals with two ordering possibilities. E.g. if you look at rows 8 and 20 the solution is 50-67<->44-86 (where 67 and 44 are interchangeable), but the formula results in double 67s, which is not in the original data.

Hi,

OK, here's a mod which now picks up and allows for there being duplicate values in a row.

**sulin360** · 08-25-2013, 08:00 PM

Hi, thanks for your help, Richard.

Is there a way to allow for such duplicates in the other places? The data I'll be restructuring has over 12000 rows, so I'm sure there will be all sorts of possible permutations of such anomalies. Here is your file where I made up some data to reveal problems with code.

Ordering one table by the rules from another table

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Ordering one table by the rules from another table

Re: Ordering one table by the rules from another table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Ordering chronologically in a pivot table

Alphabeltical ordering in table - results don't make sens

Auto-fill table values from source table with "rules" to handle multiple values?

Excel 2007 : Ordering Conditional Format Rules

Find and Replace against set of rules in 2nd table/worksheet

Bookmarks

Bookmarks

Posting Permissions