Thank you for your help, I got the problem resolved.

I used the index function and the match function to resolve this.

Thanks!

"cmckeag" wrote:

(a) the result you get

Sheet 1 (result of sort)

F F F F F 6
E E E E E 5
D D D D D 4
C C C C C 3
B B B B B 2
A A A A A 1


Sheet 2 (results of sort)

A A A A A 6
B B B B B 5
C C C C C 4
D D D D D 3
E E E E E 2
F F F F F 1



(b) the result you want

Sheet 2 should look like this:

F F F F F 6
E E E E E 5
D D D D D 4
C C C C C 3
B B B B B 2
A A A A A 1

Thank you again for looking at this. If this does not clear it up for you
can I email you the file?









"MyVeryOwnSelf" wrote:

Hopefully this clarification is better. If not please let me know.

Please post before & after showing (a) the result you get and (b) the
result you want.

Dont use the same value (like "A") in more than one place unless those
values are in fact identical.