Rank text linked to dollar sales

baindes

Board Regular
Joined
Dec 5, 2005
Messages
183
Hi there,

I need to find the rank of the item description based off it's dollar sales in a seperate sheet.

A1
1 ea blue vase 8956094
B1
I need the rank from the data dump where I pulled the description from. So this item would rank # 3 in dollar sales in an unranked data dump from worksheet called dump. Column C has the dollar sales and column D has the item description that I copied and pasted into the sheet I am trying to call the rank to. Hope this is somewhat clear.

Thank you.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,118,236
Messages
5,571,050
Members
412,359
Latest member
misstoffeepenny
Top