PDA

View Full Version : Sort + Rank 2 columns with formula



Barryj
02-27-2006, 10:02 AM
I Have 2 list of names and scores that I want to sort & rank.

A person can only appear in 1 list or the other after sorting and ranking in columns G & I,if a person appears in both columns then the next person is elevated up the list.

As the attachment shows, in column B & D before and G & I the results of how this would look after the sorting + ranking.

Column B takes precidence over column D in determining the elevation of the next person.

Hope someone can make some sense of this.:dunno