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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
Top