measuring profits

  • Thread starter Thread starter mopzig
  • Start date Start date
M

mopzig

im working on a budget spreadsheet and ive run into the problem tryin
to find the most and least profitable month. This budget is set u
rather typically , months are columns, various data addition (income
and subtraction (expense) as well as totals etc. My problem is relatin
all this data back to the months they come from. I tried using neste
IF statements saying that if Jan is the Max value (in profit column
then display 'jan', else try feb and if feb isnt try march ... i kno
there is a better way to do this but maybe i havnt given ampl
description of my situation. This seems like a real simple thing but
just cant get around it.

oh my budget spreadsheet kinda looks like this image i found 'here
(http://spreadsheets.about.com/library/graphics/exbudget15.jpg
 
Say you want the most profitable month to be displayed in column Z
And say that the profit for a given month is displayed in row 20

In cell Z1 enter
=INDEX(MATCH(MAX($B$20:$M$20),$B$20:$M$20,0),$B1:$M1)
and copy down.
(untested)
 
Back
Top