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

Report •


#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 - 36
B1 will contain the total salary for months 2 - 37
etc.

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 Rule

Use a formula to determine which cells to format

Paste 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 •


Ask Question