Hi again
26 pay checks have to be in chronological order. Then we have to find
another seperate 26 paychecks that are the second highest. And then 26
paychecks that are the 3rd highest. Maybe an example of what my spreadsheet
looks like now.
A1 $2,000.00
A2 $2,300.00
A3 $1,459.00
A26 $1,890.00 B26 =A1:A26
A27 $1,990.00 B27 =A2:A27
A126 $1,500.00 B126 = A100:A126
A127 $3,000.00 B127 = A100:A126
Line 26 is the first time we can total in column B the 26 paychecks. Line
27 is second time. Now if I do LARGE comand 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 have to check, then somewhere in the person's career another
seperate 26 checks might make up a second year.
Hope this helps clear it up. I think you knew what I meant but hope this
helps.
Thanks again!