S

#### StillLearning

solution for me.

I have a column with over 130 numbers in it (130 numbers in a single

column.). I want to bring back the largest value in an array. Then I want to

bring back the second largest values in the same array so long as it does not

fall with +/- 26 rows of the largest number.) Last I want to bring back the

third largest value that doesnâ€™t faull with +/- 26 rows of the first or

second largest numbers found earlier.

This is for a payroll. I am trying to find a personâ€™s three highest years

of earnings. My first column (A) has the dollar amount of every paycheck my

person had for each pay period (26 a year) in a five year period. Column (B)

sums 26 paychecks to come up with what 12 months of earnings would be (they

donâ€™tâ€™ have to be calendar years, they can be April 1st to March 31st for

example). I want to sum 26 consecutive paychecks and see which 26 paychecks

total the largest amount. They don't need to be in the same year, they just

need to be 26 consecutive.

Maybe an example of what my spreadsheet

looks like now.

A1 $2,000.00

A2 $2,300.00

A3 $1,459.00

(keeps goingâ€¦â€¦)

A26 $1,890.00 B26 =A1:A26

A27 $1,990.00 B27 =A2:A27

(keeps goingâ€¦.)

A126 $1,500.00 B126 = A100:A126

A127 $3,000.00 B127 = A101:A127

Line 26 is the first time we can total in column B 26 paychecks. Line

27 is second time. Now if I do LARGE command in column B, it will give me

the highest number (say its in cell B26). If I look for the second largest,

it

might give me B27. The problem with that though is that B27 includes

earnings that showed up in B26. I need to find a way that once EXCEL

determines what cell in column B is highest, when I look for second highest

it excludes the 25 cells that come in front of it (if answer is B26, then

need to exclude B1-B26). The second year might start in B127. The 26

paychecks are identified and excluded in the search for the third highest 26

pay period.

Thank you in advance for any help I can get for this question

~Patrick