Rank text linked to dollar sales

[baindes]

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.

 

[Brian from Maui]

This should get you started,

http://www.mrexcel.com/board2/viewtopic.php?t=49840

 

[baindes]

This is great, thank you.