A
ArrDubbSmith
Here is a portion of my table:
Shane $44,476.28 90.9
$67,103.19 49.2
$105,943.68 94.9
$59,601.69 92.7
$63,188.49 87.4
$81,969.00 91.6
$74,373.28 107.8
$83,153.10 91.3
$50,764.05 62.6
$62,418.70 82.8
$61,355.07 74.4
$69,577.73 87.4
Total $923,083.30 1128.8
Brantley $71,818.41 83.3
$130,694.34 126.9
$116,102.29 128.2
$97,046.07 112.6
$109,119.82 78.4
$105,529.95 111.7
$74,497.33 57.1
$77,313.42 78.3
$122,943.03 94.8
$76,781.16 80.1
$66,026.26 83.5
$63,825.67 58.4
$114,546.41 106.8
$106,373.49 102.9
Total $1,332,617.65 1302.9
Carrie $82,307.57 121.3
$86,346.00 104.8
$90,100.27 107.1
$75,660.85 82
$59,389.33 61
$92,869.60 107.9
$88,834.17 61.2
$100,069.61 93.9
$103,820.52 100.3
$89,356.33 118.4
$97,657.42 108.2
$72,090.35 64.8
$82,457.25 78.2
$75,849.17 96.4
$60,885.39 108.1
Total $1,257,693.83 1413.5
Gary $67,572.78 78
$73,145.77 91.6
$59,678.16 81.7
$69,499.44 93.7
$96,963.20 91.7
$48,403.40 111.3
$50,955.66 111.9
$67,779.97 113
$73,187.57 91.4
$5,062.19 6.9
$80,585.77 89.1
Total $692,833.91 960.4
I have no control from the data source. The names in the first column are
supervisor's names, going down the column you see 'Total' which is the
subtotals for that particular supervisor's team.
It's the subtotals that I'm trying to reference with a lookup function but
since the brianiacs don't label the data for each team with unique names.
What function could count down from a unique name (use Shane for example),
drop down to the next cell that says "Total" and rename it Shawn ... then do
the same thing for Brantley, etc??? Many Thanks to the Guru that answers
this for me.
Shane $44,476.28 90.9
$67,103.19 49.2
$105,943.68 94.9
$59,601.69 92.7
$63,188.49 87.4
$81,969.00 91.6
$74,373.28 107.8
$83,153.10 91.3
$50,764.05 62.6
$62,418.70 82.8
$61,355.07 74.4
$69,577.73 87.4
Total $923,083.30 1128.8
Brantley $71,818.41 83.3
$130,694.34 126.9
$116,102.29 128.2
$97,046.07 112.6
$109,119.82 78.4
$105,529.95 111.7
$74,497.33 57.1
$77,313.42 78.3
$122,943.03 94.8
$76,781.16 80.1
$66,026.26 83.5
$63,825.67 58.4
$114,546.41 106.8
$106,373.49 102.9
Total $1,332,617.65 1302.9
Carrie $82,307.57 121.3
$86,346.00 104.8
$90,100.27 107.1
$75,660.85 82
$59,389.33 61
$92,869.60 107.9
$88,834.17 61.2
$100,069.61 93.9
$103,820.52 100.3
$89,356.33 118.4
$97,657.42 108.2
$72,090.35 64.8
$82,457.25 78.2
$75,849.17 96.4
$60,885.39 108.1
Total $1,257,693.83 1413.5
Gary $67,572.78 78
$73,145.77 91.6
$59,678.16 81.7
$69,499.44 93.7
$96,963.20 91.7
$48,403.40 111.3
$50,955.66 111.9
$67,779.97 113
$73,187.57 91.4
$5,062.19 6.9
$80,585.77 89.1
Total $692,833.91 960.4
I have no control from the data source. The names in the first column are
supervisor's names, going down the column you see 'Total' which is the
subtotals for that particular supervisor's team.
It's the subtotals that I'm trying to reference with a lookup function but
since the brianiacs don't label the data for each team with unique names.
What function could count down from a unique name (use Shane for example),
drop down to the next cell that says "Total" and rename it Shawn ... then do
the same thing for Brantley, etc??? Many Thanks to the Guru that answers
this for me.