LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default Rank by Multi Condition

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fine-Tune Multi-Condition Formula VB Excel Worksheet Functions 2 March 1st 07 06:55 PM
Help with Multi-Condition Formula VB Excel Worksheet Functions 2 February 28th 07 08:58 PM
Rank with condition R. Choate Excel Discussion (Misc queries) 12 April 27th 06 03:51 AM
Rank items, select one start date, have remaining dates follow based on rank rob normerica Excel Discussion (Misc queries) 1 August 15th 05 09:36 PM
Multi-condition vlookup Hobbeson Excel Worksheet Functions 4 July 19th 05 02:57 AM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"