Need to find average salary over 78 pay periods

J

jennvkerr

New Member
Joined
Jun 21, 2012
Messages
21
hi there! i am trying to determine the highest average final compensation over 78 out of 166 bi-weekly payrolls.

Example:

[TABLE="width: 289"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD][TABLE="width: 289"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD] Amount [/TD]
[TD]Begin[/TD]
[TD]End [/TD]
[TD]Check Dt[/TD]
[/TR]
[TR]
[TD="align: right"]1453.92[/TD]
[TD="align: right"]5/23/2005[/TD]
[TD="align: right"]6/5/2005[/TD]
[TD="align: right"]6/10/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]6/6/2005[/TD]
[TD="align: right"]6/19/2005[/TD]
[TD="align: right"]6/24/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4861.08[/TD]
[TD="align: right"]6/20/2005[/TD]
[TD="align: right"]7/3/2005[/TD]
[TD="align: right"]7/8/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]7/4/2005[/TD]
[TD="align: right"]7/17/2005[/TD]
[TD="align: right"]7/22/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]7/18/2005[/TD]
[TD="align: right"]7/31/2005[/TD]
[TD="align: right"]8/5/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]8/1/2005[/TD]
[TD="align: right"]8/14/2005[/TD]
[TD="align: right"]8/19/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]8/15/2005[/TD]
[TD="align: right"]8/28/2005[/TD]
[TD="align: right"]9/2/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]8/29/2005[/TD]
[TD="align: right"]9/11/2005[/TD]
[TD="align: right"]9/16/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]9/12/2005[/TD]
[TD="align: right"]9/25/2005[/TD]
[TD="align: right"]9/30/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4846.4[/TD]
[TD="align: right"]9/26/2005[/TD]
[TD="align: right"]10/9/2005[/TD]
[TD="align: right"]10/14/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]10/10/2005[/TD]
[TD="align: right"]10/23/2005[/TD]
[TD="align: right"]10/28/2005[/TD]
[/TR]
[TR]
[TD="align: right"]5252.64[/TD]
[TD="align: right"]10/24/2005[/TD]
[TD="align: right"]11/6/2005[/TD]
[TD="align: right"]11/10/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]11/7/2005[/TD]
[TD="align: right"]11/20/2005[/TD]
[TD="align: right"]11/23/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]11/21/2005[/TD]
[TD="align: right"]12/4/2005[/TD]
[TD="align: right"]12/9/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]12/5/2005[/TD]
[TD="align: right"]12/18/2005[/TD]
[TD="align: right"]12/22/2005[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]12/19/2005[/TD]
[TD="align: right"]1/1/2006[/TD]
[TD="align: right"]1/6/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]1/2/2006[/TD]
[TD="align: right"]1/15/2006[/TD]
[TD="align: right"]1/20/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4897.18[/TD]
[TD="align: right"]1/16/2006[/TD]
[TD="align: right"]1/29/2006[/TD]
[TD="align: right"]2/3/2006[/TD]
[/TR]
[TR]
[TD="align: right"]5705.18[/TD]
[TD="align: right"]1/30/2006[/TD]
[TD="align: right"]2/12/2006[/TD]
[TD="align: right"]2/17/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]2/13/2006[/TD]
[TD="align: right"]2/26/2006[/TD]
[TD="align: right"]3/3/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]2/27/2006[/TD]
[TD="align: right"]3/12/2006[/TD]
[TD="align: right"]3/17/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]3/13/2006[/TD]
[TD="align: right"]3/26/2006[/TD]
[TD="align: right"]3/31/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]3/27/2006[/TD]
[TD="align: right"]4/9/2006[/TD]
[TD="align: right"]4/14/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]4/10/2006[/TD]
[TD="align: right"]4/23/2006[/TD]
[TD="align: right"]4/28/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]4/24/2006[/TD]
[TD="align: right"]5/7/2006[/TD]
[TD="align: right"]5/12/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]5/8/2006[/TD]
[TD="align: right"]5/21/2006[/TD]
[TD="align: right"]5/26/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]5/22/2006[/TD]
[TD="align: right"]6/4/2006[/TD]
[TD="align: right"]6/9/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]6/5/2006[/TD]
[TD="align: right"]6/18/2006[/TD]
[TD="align: right"]6/23/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]6/19/2006[/TD]
[TD="align: right"]7/2/2006[/TD]
[TD="align: right"]7/7/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]7/3/2006[/TD]
[TD="align: right"]7/16/2006[/TD]
[TD="align: right"]7/21/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]7/17/2006[/TD]
[TD="align: right"]7/30/2006[/TD]
[TD="align: right"]8/4/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]7/31/2006[/TD]
[TD="align: right"]8/13/2006[/TD]
[TD="align: right"]8/18/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]8/14/2006[/TD]
[TD="align: right"]8/27/2006[/TD]
[TD="align: right"]9/1/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]8/28/2006[/TD]
[TD="align: right"]9/10/2006[/TD]
[TD="align: right"]9/15/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]9/11/2006[/TD]
[TD="align: right"]9/24/2006[/TD]
[TD="align: right"]9/29/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]9/25/2006[/TD]
[TD="align: right"]10/8/2006[/TD]
[TD="align: right"]10/13/2006[/TD]
[/TR]
[TR]
[TD="align: right"]4977.98[/TD]
[TD="align: right"]10/9/2006[/TD]
[TD="align: right"]10/22/2006[/TD]
[TD="align: right"]10/27/2006[/TD]
[/TR]
[TR]
[TD="align: right"]5717.18[/TD]
[TD="align: right"]10/23/2006[/TD]
[TD="align: right"]11/5/2006[/TD]
[TD="align: right"]11/9/2006[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]11/6/2006[/TD]
[TD="align: right"]11/19/2006[/TD]
[TD="align: right"]11/22/2006[/TD]
[/TR]
[TR]
[TD="align: right"]6509.28[/TD]
[TD="align: right"]11/20/2006[/TD]
[TD="align: right"]12/3/2006[/TD]
[TD="align: right"]12/8/2006[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]12/4/2006[/TD]
[TD="align: right"]12/17/2006[/TD]
[TD="align: right"]12/22/2006[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]12/18/2006[/TD]
[TD="align: right"]12/31/2006[/TD]
[TD="align: right"]1/5/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]1/1/2007[/TD]
[TD="align: right"]1/14/2007[/TD]
[TD="align: right"]1/19/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]1/15/2007[/TD]
[TD="align: right"]1/28/2007[/TD]
[TD="align: right"]2/2/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]1/29/2007[/TD]
[TD="align: right"]2/11/2007[/TD]
[TD="align: right"]2/16/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]2/12/2007[/TD]
[TD="align: right"]2/25/2007[/TD]
[TD="align: right"]3/2/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]2/26/2007[/TD]
[TD="align: right"]3/11/2007[/TD]
[TD="align: right"]3/16/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]3/12/2007[/TD]
[TD="align: right"]3/25/2007[/TD]
[TD="align: right"]3/30/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]3/26/2007[/TD]
[TD="align: right"]4/8/2007[/TD]
[TD="align: right"]4/13/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]4/9/2007[/TD]
[TD="align: right"]4/22/2007[/TD]
[TD="align: right"]4/27/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]4/23/2007[/TD]
[TD="align: right"]5/6/2007[/TD]
[TD="align: right"]5/11/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]5/7/2007[/TD]
[TD="align: right"]5/20/2007[/TD]
[TD="align: right"]5/25/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]5/21/2007[/TD]
[TD="align: right"]6/3/2007[/TD]
[TD="align: right"]6/8/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]6/4/2007[/TD]
[TD="align: right"]6/17/2007[/TD]
[TD="align: right"]6/22/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]6/18/2007[/TD]
[TD="align: right"]7/1/2007[/TD]
[TD="align: right"]7/6/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]7/2/2007[/TD]
[TD="align: right"]7/15/2007[/TD]
[TD="align: right"]7/20/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]7/16/2007[/TD]
[TD="align: right"]7/29/2007[/TD]
[TD="align: right"]8/3/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]7/30/2007[/TD]
[TD="align: right"]8/12/2007[/TD]
[TD="align: right"]8/17/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]8/13/2007[/TD]
[TD="align: right"]8/26/2007[/TD]
[TD="align: right"]8/31/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]8/27/2007[/TD]
[TD="align: right"]9/9/2007[/TD]
[TD="align: right"]9/14/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]9/10/2007[/TD]
[TD="align: right"]9/23/2007[/TD]
[TD="align: right"]9/28/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5224.38[/TD]
[TD="align: right"]9/24/2007[/TD]
[TD="align: right"]10/7/2007[/TD]
[TD="align: right"]10/12/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5741.18[/TD]
[TD="align: right"]10/8/2007[/TD]
[TD="align: right"]10/21/2007[/TD]
[TD="align: right"]10/26/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/22/2007[/TD]
[TD="align: right"]11/4/2007[/TD]
[TD="align: right"]11/9/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]11/5/2007[/TD]
[TD="align: right"]11/18/2007[/TD]
[TD="align: right"]11/21/2007[/TD]
[/TR]
[TR]
[TD="align: right"]14752.08[/TD]
[TD="align: right"]11/19/2007[/TD]
[TD="align: right"]12/2/2007[/TD]
[TD="align: right"]12/7/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/3/2007[/TD]
[TD="align: right"]12/16/2007[/TD]
[TD="align: right"]12/21/2007[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/17/2007[/TD]
[TD="align: right"]12/30/2007[/TD]
[TD="align: right"]1/4/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/31/2007[/TD]
[TD="align: right"]1/13/2008[/TD]
[TD="align: right"]1/18/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/14/2008[/TD]
[TD="align: right"]1/27/2008[/TD]
[TD="align: right"]2/1/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/28/2008[/TD]
[TD="align: right"]2/10/2008[/TD]
[TD="align: right"]2/15/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/11/2008[/TD]
[TD="align: right"]2/24/2008[/TD]
[TD="align: right"]2/29/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/25/2008[/TD]
[TD="align: right"]3/9/2008[/TD]
[TD="align: right"]3/14/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/10/2008[/TD]
[TD="align: right"]3/23/2008[/TD]
[TD="align: right"]3/28/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/24/2008[/TD]
[TD="align: right"]4/6/2008[/TD]
[TD="align: right"]4/11/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/7/2008[/TD]
[TD="align: right"]4/20/2008[/TD]
[TD="align: right"]4/25/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/21/2008[/TD]
[TD="align: right"]5/4/2008[/TD]
[TD="align: right"]5/9/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/5/2008[/TD]
[TD="align: right"]5/18/2008[/TD]
[TD="align: right"]5/23/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/19/2008[/TD]
[TD="align: right"]6/1/2008[/TD]
[TD="align: right"]6/6/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]6/2/2008[/TD]
[TD="align: right"]6/15/2008[/TD]
[TD="align: right"]6/20/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]6/16/2008[/TD]
[TD="align: right"]6/29/2008[/TD]
[TD="align: right"]7/3/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]6/30/2008[/TD]
[TD="align: right"]7/13/2008[/TD]
[TD="align: right"]7/18/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]7/14/2008[/TD]
[TD="align: right"]7/27/2008[/TD]
[TD="align: right"]8/1/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]7/28/2008[/TD]
[TD="align: right"]8/10/2008[/TD]
[TD="align: right"]8/15/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]8/11/2008[/TD]
[TD="align: right"]8/24/2008[/TD]
[TD="align: right"]8/29/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]8/25/2008[/TD]
[TD="align: right"]9/7/2008[/TD]
[TD="align: right"]9/12/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]9/8/2008[/TD]
[TD="align: right"]9/21/2008[/TD]
[TD="align: right"]9/26/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]9/22/2008[/TD]
[TD="align: right"]10/5/2008[/TD]
[TD="align: right"]10/10/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/6/2008[/TD]
[TD="align: right"]10/19/2008[/TD]
[TD="align: right"]10/24/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/20/2008[/TD]
[TD="align: right"]11/2/2008[/TD]
[TD="align: right"]11/7/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]11/3/2008[/TD]
[TD="align: right"]11/16/2008[/TD]
[TD="align: right"]11/21/2008[/TD]
[/TR]
[TR]
[TD="align: right"]10074.35[/TD]
[TD="align: right"]11/17/2008[/TD]
[TD="align: right"]11/30/2008[/TD]
[TD="align: right"]12/5/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/1/2008[/TD]
[TD="align: right"]12/14/2008[/TD]
[TD="align: right"]12/19/2008[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/15/2008[/TD]
[TD="align: right"]12/28/2008[/TD]
[TD="align: right"]1/2/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/29/2008[/TD]
[TD="align: right"]1/11/2009[/TD]
[TD="align: right"]1/16/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/12/2009[/TD]
[TD="align: right"]1/25/2009[/TD]
[TD="align: right"]1/30/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/26/2009[/TD]
[TD="align: right"]2/8/2009[/TD]
[TD="align: right"]2/13/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/9/2009[/TD]
[TD="align: right"]2/22/2009[/TD]
[TD="align: right"]2/27/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/23/2009[/TD]
[TD="align: right"]3/8/2009[/TD]
[TD="align: right"]3/13/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/9/2009[/TD]
[TD="align: right"]3/22/2009[/TD]
[TD="align: right"]3/27/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/23/2009[/TD]
[TD="align: right"]4/5/2009[/TD]
[TD="align: right"]4/10/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/6/2009[/TD]
[TD="align: right"]4/19/2009[/TD]
[TD="align: right"]4/24/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/20/2009[/TD]
[TD="align: right"]5/3/2009[/TD]
[TD="align: right"]5/8/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/4/2009[/TD]
[TD="align: right"]5/17/2009[/TD]
[TD="align: right"]5/22/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/18/2009[/TD]
[TD="align: right"]5/31/2009[/TD]
[TD="align: right"]6/5/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]6/1/2009[/TD]
[TD="align: right"]6/14/2009[/TD]
[TD="align: right"]6/19/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]6/15/2009[/TD]
[TD="align: right"]6/28/2009[/TD]
[TD="align: right"]7/2/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]6/29/2009[/TD]
[TD="align: right"]7/12/2009[/TD]
[TD="align: right"]7/17/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]7/13/2009[/TD]
[TD="align: right"]7/26/2009[/TD]
[TD="align: right"]7/31/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]7/27/2009[/TD]
[TD="align: right"]8/9/2009[/TD]
[TD="align: right"]8/14/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]8/10/2009[/TD]
[TD="align: right"]8/23/2009[/TD]
[TD="align: right"]8/28/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]8/24/2009[/TD]
[TD="align: right"]9/6/2009[/TD]
[TD="align: right"]9/11/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]9/7/2009[/TD]
[TD="align: right"]9/20/2009[/TD]
[TD="align: right"]9/25/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]9/21/2009[/TD]
[TD="align: right"]10/4/2009[/TD]
[TD="align: right"]10/9/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/5/2009[/TD]
[TD="align: right"]10/18/2009[/TD]
[TD="align: right"]10/23/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/19/2009[/TD]
[TD="align: right"]11/1/2009[/TD]
[TD="align: right"]11/6/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]11/2/2009[/TD]
[TD="align: right"]11/15/2009[/TD]
[TD="align: right"]11/20/2009[/TD]
[/TR]
[TR]
[TD="align: right"]8334.58[/TD]
[TD="align: right"]11/16/2009[/TD]
[TD="align: right"]11/29/2009[/TD]
[TD="align: right"]12/4/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]11/30/2009[/TD]
[TD="align: right"]12/13/2009[/TD]
[TD="align: right"]12/18/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/14/2009[/TD]
[TD="align: right"]12/27/2009[/TD]
[TD="align: right"]12/30/2009[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/28/2009[/TD]
[TD="align: right"]1/10/2010[/TD]
[TD="align: right"]1/15/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/11/2010[/TD]
[TD="align: right"]1/24/2010[/TD]
[TD="align: right"]1/29/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/25/2010[/TD]
[TD="align: right"]2/7/2010[/TD]
[TD="align: right"]2/12/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/8/2010[/TD]
[TD="align: right"]2/21/2010[/TD]
[TD="align: right"]2/26/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/22/2010[/TD]
[TD="align: right"]3/7/2010[/TD]
[TD="align: right"]3/12/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/8/2010[/TD]
[TD="align: right"]3/21/2010[/TD]
[TD="align: right"]3/26/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/22/2010[/TD]
[TD="align: right"]4/4/2010[/TD]
[TD="align: right"]4/9/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/5/2010[/TD]
[TD="align: right"]4/18/2010[/TD]
[TD="align: right"]4/23/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/19/2010[/TD]
[TD="align: right"]5/2/2010[/TD]
[TD="align: right"]5/7/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/3/2010[/TD]
[TD="align: right"]5/16/2010[/TD]
[TD="align: right"]5/21/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/17/2010[/TD]
[TD="align: right"]5/30/2010[/TD]
[TD="align: right"]6/4/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/31/2010[/TD]
[TD="align: right"]6/13/2010[/TD]
[TD="align: right"]6/18/2010[/TD]
[/TR]
[TR]
[TD="align: right"]6704.98[/TD]
[TD="align: right"]6/14/2010[/TD]
[TD="align: right"]6/27/2010[/TD]
[TD="align: right"]7/2/2010[/TD]
[/TR]
[TR]
[TD="align: right"]6704.98[/TD]
[TD="align: right"]6/14/2010[/TD]
[TD="align: right"]6/27/2010[/TD]
[TD="align: right"]7/2/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]7/12/2010[/TD]
[TD="align: right"]7/25/2010[/TD]
[TD="align: right"]7/30/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]7/26/2010[/TD]
[TD="align: right"]8/8/2010[/TD]
[TD="align: right"]8/13/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]8/9/2010[/TD]
[TD="align: right"]8/22/2010[/TD]
[TD="align: right"]8/27/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]8/23/2010[/TD]
[TD="align: right"]9/5/2010[/TD]
[TD="align: right"]9/10/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]9/6/2010[/TD]
[TD="align: right"]9/19/2010[/TD]
[TD="align: right"]9/24/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]9/20/2010[/TD]
[TD="align: right"]10/3/2010[/TD]
[TD="align: right"]10/8/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/4/2010[/TD]
[TD="align: right"]10/17/2010[/TD]
[TD="align: right"]10/22/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]10/18/2010[/TD]
[TD="align: right"]10/31/2010[/TD]
[TD="align: right"]11/5/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]11/1/2010[/TD]
[TD="align: right"]11/14/2010[/TD]
[TD="align: right"]11/19/2010[/TD]
[/TR]
[TR]
[TD="align: right"]13630.78[/TD]
[TD="align: right"]11/15/2010[/TD]
[TD="align: right"]11/28/2010[/TD]
[TD="align: right"]12/3/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]11/29/2010[/TD]
[TD="align: right"]12/12/2010[/TD]
[TD="align: right"]12/17/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/13/2010[/TD]
[TD="align: right"]12/26/2010[/TD]
[TD="align: right"]12/29/2010[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]12/27/2010[/TD]
[TD="align: right"]1/9/2011[/TD]
[TD="align: right"]1/14/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/10/2011[/TD]
[TD="align: right"]1/23/2011[/TD]
[TD="align: right"]1/28/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]1/24/2011[/TD]
[TD="align: right"]2/6/2011[/TD]
[TD="align: right"]2/11/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/7/2011[/TD]
[TD="align: right"]2/20/2011[/TD]
[TD="align: right"]2/25/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]2/21/2011[/TD]
[TD="align: right"]3/6/2011[/TD]
[TD="align: right"]3/11/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/7/2011[/TD]
[TD="align: right"]3/20/2011[/TD]
[TD="align: right"]3/25/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]3/21/2011[/TD]
[TD="align: right"]4/3/2011[/TD]
[TD="align: right"]4/8/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/4/2011[/TD]
[TD="align: right"]4/17/2011[/TD]
[TD="align: right"]4/22/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]4/18/2011[/TD]
[TD="align: right"]5/1/2011[/TD]
[TD="align: right"]5/6/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/2/2011[/TD]
[TD="align: right"]5/15/2011[/TD]
[TD="align: right"]5/20/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/16/2011[/TD]
[TD="align: right"]5/29/2011[/TD]
[TD="align: right"]6/3/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5482.78[/TD]
[TD="align: right"]5/30/2011[/TD]
[TD="align: right"]6/12/2011[/TD]
[TD="align: right"]6/17/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5075.58[/TD]
[TD="align: right"]6/13/2011[/TD]
[TD="align: right"]6/26/2011[/TD]
[TD="align: right"]7/1/2011[/TD]
[/TR]
[TR]
[TD="align: right"]4573.1[/TD]
[TD="align: right"]6/27/2011[/TD]
[TD="align: right"]7/10/2011[/TD]
[TD="align: right"]7/15/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5075.58[/TD]
[TD="align: right"]7/11/2011[/TD]
[TD="align: right"]7/24/2011[/TD]
[TD="align: right"]7/29/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5075.58[/TD]
[TD="align: right"]7/25/2011[/TD]
[TD="align: right"]8/7/2011[/TD]
[TD="align: right"]8/12/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5075.58[/TD]
[TD="align: right"]8/8/2011[/TD]
[TD="align: right"]8/21/2011[/TD]
[TD="align: right"]8/26/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5075.58[/TD]
[TD="align: right"]8/22/2011[/TD]
[TD="align: right"]9/4/2011[/TD]
[TD="align: right"]9/9/2011[/TD]
[/TR]
[TR]
[TD="align: right"]4573.1[/TD]
[TD="align: right"]9/5/2011[/TD]
[TD="align: right"]9/18/2011[/TD]
[TD="align: right"]9/23/2011[/TD]
[/TR]
[TR]
[TD="align: right"]5075.58[/TD]
[TD="align: right"]9/19/2011[/TD]
[TD="align: right"]10/2/2011[/TD]
[TD="align: right"]10/7/2011[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
The following formula will give you the average of the top 78 values between A2-A167

=(SUMIF($A$2:$A$167,">"&LARGE($A$2:$A$167,78))+((78-COUNTIF($A$2:$A$167,">"&LARGE($A$2:$A$167,78)))*LARGE($A$2:$A$167,78)))/78
 
Upvote 0
Do you know the result that you want?

Do you need the maximum consecutive range of 78 numbers?

Consider in H2 =AVERAGE(A2:OFFSET(A2,77,0))

then =MAX(H2:H167)
 
Upvote 0
Hi, thank you! I also have to be sure that these are consecutive 78 payrolls. Does this formula account for that? THank you!
 
Upvote 0
sorry, i'm not quite following - what is H2 and why should i then take the max? thank you so much for your help!!
 
Upvote 0
Assuming your data is in A2:D167, in E79 use =average(D2:D79). Drag this formula down through E167. Then in any unused cell =MAX(E79:E167). It may be possible to do this in one array formula, but I'm not the person to do that.
 
Upvote 0
Enter the formula into cell H2 and then copy the formula down.

The Max formula will determine the largest range of 78 cells.
 
Upvote 0
If you do not want to use the helper column, try the following Array Formula

=MAX(SUBTOTAL(1,OFFSET(A2,ROW(A2:A78)-ROW(A2),,78)))

Enter the formula with Control+Shift+Enter not just Enter.
 
Upvote 0
The array formula for the data range that you cited is

=MAX(SUBTOTAL(1,OFFSET(A2,ROW(A2:A167)-ROW(A2),,78)))
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Compile error: Wrong number of arguments or invalid property assignment
Replies
2
Views
55
daveyc18
D
G
  • Solved
If Else Loop macro running slow, anyway to speed it up?
Replies
9
Views
258
Alex Blakenburg
A
A
  • Question Question
Need to convert value depending on currency and date
Replies
2
Views
450
deLockloire
D
E
  • Question Question
If statement
Replies
4
Views
107
xlhelp15
xlhelp15
A
  • Solved
Lookup PAAF ID based on Worker ID and date range
Replies
3
Views
114
Fluff
Fluff

Forum statistics

Threads
1,223,236
Messages
6,170,906
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top