Hi
I’m trying to set up a spreadsheet as shown below. I used to only have a “Current Month” and “Previous Month” fields which made ranking very easy as I only had 2 columns. However my girlfriend now wants to have yearly totals included.
I figured to do this I need to have 2 external fields which have the current and previous months (as I have in cells B1 and B2) and then use some kind of lookup to those cells to then pick out the ranking of the correct months column. So that is B1 showed Oct-11 then it would rank based on Column E, however if B1 changed to Apr-12 then it would calculate the ranks based on Column K
Is this do-able? As its for the mrs I’d rather it auto-calculate the ranks rather than her changing the Ranking formulae each month.
I’m trying to set up a spreadsheet as shown below. I used to only have a “Current Month” and “Previous Month” fields which made ranking very easy as I only had 2 columns. However my girlfriend now wants to have yearly totals included.
I figured to do this I need to have 2 external fields which have the current and previous months (as I have in cells B1 and B2) and then use some kind of lookup to those cells to then pick out the ranking of the correct months column. So that is B1 showed Oct-11 then it would rank based on Column E, however if B1 changed to Apr-12 then it would calculate the ranks based on Column K
Is this do-able? As its for the mrs I’d rather it auto-calculate the ranks rather than her changing the Ranking formulae each month.
