Thanks for your response. I did visit the site, prior to this posting.
It is a simple concatenation of type and source. I want to achieve the
result with a single formula.

"Chip Pearson" wrote:

What is the criteria by which the projects are ranked? Is it a simple
concatenation of type and source? Or is there more to the ranking than that?
You might find the ranking formulas on discussed on my web site useful:
http://www.cpearson.com/excel/rank.htm

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

Depending on what the ranking rules are, you may need to include a column to
hold intermediate results. This column could,of course, be hidden.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Ananth" wrote in message
...
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