I am looking for a RankIf solution. I would prefer not to use VBA if at all possible. This is for a co-worker and I don't want to have to support it. In the example below, I have the agent and sales. I would like to create the rank column with a formula. I want to rank sales by agent. The goal is to avoid sorting or filtering. I tried an array type formula and got errors;
=rank(C3,(1*($B$3:$B$11=B3))*$C$3:$C$11), but this produced an error - The formula you typed contains errors.
Any ideas? Silly mistake? Thanks.
=rank(C3,(1*($B$3:$B$11=B3))*$C$3:$C$11), but this produced an error - The formula you typed contains errors.
Any ideas? Silly mistake? Thanks.
| Book6 | ||||||
|---|---|---|---|---|---|---|
| B | C | D | E | |||
| 2 | Agent | Sales | Rank | |||
| 3 | AA | 1 | 3 | |||
| 4 | AB | 2 | 3 | |||
| 5 | AC | 3 | 3 | |||
| 6 | AA | 4 | 2 | |||
| 7 | AB | 5 | 2 | |||
| 8 | AC | 6 | 2 | |||
| 9 | AA | 7 | 1 | |||
| 10 | AB | 8 | 1 | |||
| 11 | AC | 9 | 1 | |||
Sheet1 | ||||||
We would want to exclude such, don't we?
, having just given a large chunk (April 15) as well a couple of hunks of my backside to said predator. 
