Ranking by type
 

i have a list of items that need to be rank by type. example:

col A Col b Col c
Item # Type
1 A 89%
2 B 78%
3 B 66%
4 C 77%
5 A 78.8%
6 C 67%
etc..

of course the list is a little longer but continguous. i want to have
rankings ascending by value in column C and by Type (column B). So, Item 5,
would be ranked #1 out of the A pool and item 1 would be #2 in A pool.

if someone could help me out that would be greeat.

Ranking by type
 

Try this:

=SUMPRODUCT(--(B$2:B$7=B2),--(C2C$2:C$7))+1

Copy down as needed

--
Biff
Microsoft Excel MVP


"Steven Cheng" wrote in message
...
i have a list of items that need to be rank by type. example:

col A Col b Col c
Item # Type
1 A 89%
2 B 78%
3 B 66%
4 C 77%
5 A 78.8%
6 C 67%
etc..

of course the list is a little longer but continguous. i want to have
rankings ascending by value in column C and by Type (column B). So, Item
5,
would be ranked #1 out of the A pool and item 1 would be #2 in A pool.

if someone could help me out that would be greeat.

Ranking by type
 

What does the -- mean or do?

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(B$2:B$7=B2),--(C2C$2:C$7))+1

Copy down as needed

--
Biff
Microsoft Excel MVP


"Steven Cheng" wrote in message
...
i have a list of items that need to be rank by type. example:

col A Col b Col c
Item # Type
1 A 89%
2 B 78%
3 B 66%
4 C 77%
5 A 78.8%
6 C 67%
etc..

of course the list is a little longer but continguous. i want to have
rankings ascending by value in column C and by Type (column B). So, Item
5,
would be ranked #1 out of the A pool and item 1 would be #2 in A pool.

if someone could help me out that would be greeat.

Ranking by type
 

See these:

http://xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

--
Biff
Microsoft Excel MVP


"Ranking by type, and the dashes" <Ranking by type, and the
wrote in message
...
What does the -- mean or do?

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(B$2:B$7=B2),--(C2C$2:C$7))+1

Copy down as needed

--
Biff
Microsoft Excel MVP


"Steven Cheng" wrote in message
...
i have a list of items that need to be rank by type. example:

col A Col b Col c
Item # Type
1 A 89%
2 B 78%
3 B 66%
4 C 77%
5 A 78.8%
6 C 67%
etc..

of course the list is a little longer but continguous. i want to have
rankings ascending by value in column C and by Type (column B). So,
Item
5,
would be ranked #1 out of the A pool and item 1 would be #2 in A pool.

if someone could help me out that would be greeat.