# excel formula to find highest 36 consecutive

February 4, 2011 at 17:38:25
Specs: Windows 7
 i am trying to find my highest 36 consecutive months out of 10 years of pay

See More: excel formula to find highest 36 consecutive

#1
February 4, 2011 at 19:15:34
 Is there a reason you are telling us what you are trying to do?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
February 4, 2011 at 19:19:56
 Yes, I can not figure out how to find the highest 36 constitutive months in a 10 year period.

Report •

#3
February 4, 2011 at 19:27:11
 So, are you asking for our help? It's hard to tell because I don't see a question in either of your posts.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

#4
February 4, 2011 at 19:31:02
 I am sorry i do not have a lot of experience on posting questions. Yes I would love some help. How do you find the highest 36 consecutive months of pay in a column of pay over 10 years?

Report •

#5
February 4, 2011 at 19:51:55
 re: "I am sorry i do not have a lot of experience on posting questions."It's really no different than asking a question face to face. I doubt you would walk up to a co-worker and just blurt out what you want. I assume you would ask them nicely to help you. It should be no different in an on-line forum.Assuming your "column of pay" is monthly, meaning that you have 120 values, try this:With your monthly pay in A1:A120, put this formula in B1 and drag it down to B85:=SUM(A1:A36)B1 will contain the total salary for months 1 - 36B1 will contain the total salary for months 2 - 37etc.The maximum value in B1:B85 will be next to first pay in the highest 36 month period.To make it easy to spot, select A1:A85 and choose Format...Conditional Formatting.Use Formula Is: =IF(SUM(A1:A36)=MAX(B:B),1,0)Choose a Conditional Formatting fill color or font.The highlighted pay will be the first pay in the highest 36 month period.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#6
February 4, 2011 at 20:27:13
 Thanks, I am getting there. I am having difficulty with the conditional formatting. I can not find were i can enter the formula.I do appreciate your help.poolhawg

Report •

#7
February 4, 2011 at 20:31:18
 What version of Excel are you running?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#8
February 4, 2011 at 20:45:31
 I am using version 2007

Report •

#9
February 4, 2011 at 20:58:27
 Conditional Formatting...New RuleUse a formula to determine which cells to formatPaste the formula in the box below the line:Format values where this formula is true:Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#10
February 5, 2011 at 11:10:30
 Thanks for all your input. I did not master the Use Formula Is: =IF(SUM(A1:A36)=MAX(B:B),1,0), but I do think I can now see my highest 36 consecutive. I really appreciate the help.poolhawg

Report •