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.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ArrDubbSmith" wrote in message
...
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.