Rank If - SumProduct - HELP PLEASE

[david]

This is my first post

I was wondering if someone could help me with the following

Here are the results that I am looking for from the data below. - data
will be 50k+ rows long! and columns can all have numerical values

I have no problems with adding some concat columns if needed

#1 VENDOR (sales ranked descending) – from, a concat of Store & Dept &
Vendor
#2 VENDOR (sales ranked descending) – from, a concat of Dept & Vendor
#3 Rank of TOP 5 Vendors from Col B
#4 Rank of Bottom 5 Vendors from Col B

Dept Store Vendor Sales
1 101 500 100
2 102 600 50
3 101 700 20
4 102 500 25
5 101 600 15
1 102 700 150
2 101 500 175
3 102 600 200
4 101 700 225
5 102 500 100
1 101 600 50
2 102 700 20
3 101 500 25
4 102 600 15
5 101 700 150
1 102 500 175

 

[Glenn]

This is my first post

I was wondering if someone could help me with the following

Here are the results that I am looking for from the data below. - data
will be 50k+ rows long! and columns can all have numerical values

I have no problems with adding some concat columns if needed

#1 VENDOR (sales ranked descending) – from, a concat of Store & Dept &
Vendor
#2 VENDOR (sales ranked descending) – from, a concat of Dept & Vendor
#3 Rank of TOP 5 Vendors from Col B
#4 Rank of Bottom 5 Vendors from Col B

Dept Store Vendor Sales
1 101 500 100
2 102 600 50
3 101 700 20
4 102 500 25
5 101 600 15
1 102 700 150
2 101 500 175
3 102 600 200
4 101 700 225
5 102 500 100
1 101 600 50
2 102 700 20
3 101 500 25
4 102 600 15
5 101 700 150
1 102 500 175

You might want to consider a PivotTable for this. If you are not familiar with
them, look here:


http://www.peltiertech.com/Excel/Pivots/pivottables.htm