sumproduct and rank

[Schubby10]

Hi there looking to count all values that are of the same account as well as same names and then rank them by balance.

I believe this is a two step process but I can not figure out how to get started.

In column D I have the account numbers
In column H I have names
In column R I have balances

Data appears like this
Rank Count
122 Bob 1000 1 1
122 Jen .01 3 2
345 Ashley 2000 1 1
345 Ashley 2000 1 1
125 Jeff 100 1 1
364 Mark 100 1 1
122 Bob 1000 1 1
122 Josh 100 2 3

 

[DanteAmor]

Maybe you need a pivot table.

From the example you put, you could put the result you expect

 

[Schubby10]

Thanks dante but I am looking to drop data and then have helper cells pull to another sheet. Is this possible?

 

[DanteAmor]

You could give the complete example of what you have and what you expect of result.

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.