Ranking Percent of Increase

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 21 Mar 2007 15:12 GMT

I'm trying to rank a percent of increase. In my worksheet (Worksheet 1), I
have This Year's sales information in column A and Last Year's sales
information in column B.

I want to find the percent of increase of A over B and then rank the
resulting percent against a row of percentages (Worksheet 2, Row 1, Columns
A:AC)

Signature

Any help?

Reply to this Message

Jim - 21 Mar 2007 15:38 GMT

Please disregard. I had the formula correct, it was just including DIV/O
results.

Signature

Thanks for all you do!

> I'm trying to rank a percent of increase. In my worksheet (Worksheet 1), I
> have This Year's sales information in column A and Last Year's sales
[quoted text clipped - 3 lines]
> resulting percent against a row of percentages (Worksheet 2, Row 1, Columns
> A:AC)

Reply to this Message