You can create a userform that would sort a highlighted range.

There is a useful tutorial on xl-logic.com where I found out how to do it.
#

"Ananth" wrote:

I am working on reviewing 2000 projects across the globe. I would like rank
the projects based on type & source (Internal and External)

A B C D E
Project Type Source Saving Rank
Pr-1 S I 10 3
Pr-2 S E 11 7
Pr-3 W E 23 11
Pr-4 W E 15 12
Pr-5 S I 16 1
Pr-6 S E 18 4
Pr-7 W I 14 10
Pr-8 S I 15 2
Pr-9 W I 15 9
Pr-10 S E 12 6
Pr-11 S E 13 5
Pr-12 S E 9 8

I want to see the result in colm E by a SINGLE FORMULA.

Thanks