Formula to calculate Rank and % growth

E

Excel Dumbo

Hello ,

Can you please help me create

1,a formula to calculate rank for the customers and
2,a formula to calculate % YTD growth for selected customers from tw
different worksheets

as given in the attached excel file ?


Thanks a lot .

Regards,
Excel Dumb

+-------------------------------------------------------------------
|Filename: Formula to calculate Rank and % growth.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=561
+-------------------------------------------------------------------
 
S

Spencer101

Excel said:
Hello ,

Can you please help me create

1,a formula to calculate rank for the customers and
2,a formula to calculate % YTD growth for selected customers from tw
different worksheets

as given in the attached excel file ?


Thanks a lot .

Regards,
Excel Dumbo
Click to expand...

Is this what you mean

+-------------------------------------------------------------------
|Filename: Excel Dumbo - Formula to calculate Rank and % growth.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=562
+-------------------------------------------------------------------
 
E

Excel Dumbo

Thanks a lot Spencer

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to calculate commission based on sliding scale 2
Dropdownlist and Vlookup 6
Look UP formula for 2 and 3 conditions 1
Complicated Match Formula with conditions 2
Look UP and then caluclation with IS ERROR 3
Excel Formula 2
LookUP certain words and return back corresponding values 2
Permanently link formula references to Column Names and not Column Cell Numbers 1

Top