Counting the instances of many alphanumeric values across a wide range.

[claytont454]

I'm hoping someone here knows a better way than my current method that takes about 6 hours of messing around between Excel and Access as a beginner/intermediate user.

I'm working with a table that is about 15000 rows by 18 columns.
Column A is a person's initials, and the rest of the row shows a code for different activities that person did in a single day.
Since this represents several months, each person's initials appears in column A of the table many times.
Sometimes they only have 1 activity for the day, or they may have 15 or 20 in a day.
There are thousands of potential "codes" that may appear in the rest of the columns, and each has a specific meaning.
This is from the healthcare world, so some codes start with a 0, others start with a letter, and they may have one or two or no decimals, and each is meaningful.

My task is to create a list for each person that shows how many times each code appeared for them on all the days represented. Here is a short snippet of my raw data (this is junk data, so there's no confidentiality issues):

[TABLE="width: 822"]
<tbody>[TR]
[TD]Name[/TD]
[TD]SDC[/TD]
[TD]SDC1[/TD]
[TD]SDC2[/TD]
[TD]SDC3[/TD]
[TD]SDC4[/TD]
[TD]SDC5[/TD]
[TD]SDC6[/TD]
[TD]SDC7[/TD]
[TD]SDC8[/TD]
[TD]SDC9[/TD]
[TD]SDC10[/TD]
[TD]SDC11[/TD]
[/TR]
[TR]
[TD]MB[/TD]
[TD]729.5[/TD]
[TD]V57.1[/TD]
[TD]V12.72[/TD]
[TD] 414.00[/TD]
[TD] 250.00[/TD]
[TD] 401.1[/TD]
[TD] 272.4[/TD]
[TD] 333.94[/TD]
[TD] 600.90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MM[/TD]
[TD]729.5[/TD]
[TD]719.41[/TD]
[TD] V57.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DLV[/TD]
[TD]724.2[/TD]
[TD]V57.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AEB[/TD]
[TD]723.1[/TD]
[TD]781.2[/TD]
[TD] V57.1[/TD]
[TD] 295.90[/TD]
[TD] 318.0[/TD]
[TD] 781.0[/TD]
[TD] 715.96[/TD]
[TD] 244.9[/TD]
[TD] 401.9[/TD]
[TD] 272.4[/TD]
[TD] V74.1[/TD]
[TD] V04.81[/TD]
[/TR]
[TR]
[TD]AS[/TD]
[TD]727.41[/TD]
[TD]V57.21[/TD]
[TD] 354.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SLM[/TD]
[TD]959.4[/TD]
[TD]V57.21[/TD]
[TD] V62.84[/TD]
[TD] V62.85[/TD]
[TD] 244.9[/TD]
[TD] 493.90[/TD]
[TD] 304.80[/TD]
[TD] 296.90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TM[/TD]
[TD]340[/TD]
[TD]729.89[/TD]
[TD] 726.2[/TD]
[TD] V57.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MB[/TD]
[TD]V76.51[/TD]
[TD]562.10[/TD]
[TD] V16.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JK[/TD]
[TD]847[/TD]
[TD]V57.1[/TD]
[TD]569.0[/TD]
[TD] 455.2[/TD]
[TD] 455.3[/TD]
[TD] V16.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AH[/TD]
[TD]840.9[/TD]
[TD]V57.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]... [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
When I sort by Column A, 'MB' might have 75 rows, 'AEB' might have 113 rows, and so on. In the end, I want to show them sorted like this with each value and how many times it appears for that person, then the next person and the same list for them. The ideal would be to just show the top 10 for each, but that may be too much to ask.
AEB [TABLE="width: 378"]
<tbody>[TR]
[TD]E000.9[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]558.9[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]401.9[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]E849.0[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]276.51[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]E849.9[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]780.6[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]303[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]79.99[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]

MM
[TABLE="width: 378"]
<tbody>[TR]
[TD]V76.44[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD]V65.3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]733[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]780.79[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]414[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]211.3[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]599[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]276.1[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]724.5[/TD]
[TD="align: right"]15[/TD]
[/TR]
</tbody>[/TABLE]
and so on. Any help you can offer is appreciated!!!

 

[Marcelo Branco]

Hi and welcome to Mr Excel Forum

Maybe this can help

See this
Excel Reverse PivotTable

Follow
Part A
Part B till step 5 (do not perform step 6)

You are here (using your data sample)

[TABLE="width: 582"]
<tbody>[TR]
[TD="class: xl63, width: 127"]Count of Value
[/TD]
[TD="class: xl63, width: 136"]Column Labels
[/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 45"][/TD]
[TD="class: xl63, width: 45"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 38"][/TD]
[TD="class: xl63, width: 75"][/TD]
[/TR]
[TR]
[TD="class: xl63"]Row Labels
[/TD]
[TD="class: xl63"]SDC
[/TD]
[TD="class: xl63"]SDC1
[/TD]
[TD="class: xl63"]SDC10
[/TD]
[TD="class: xl63"]SDC11
[/TD]
[TD="class: xl63"]SDC2
[/TD]
[TD="class: xl63"]SDC3
[/TD]
[TD="class: xl63"]SDC4
[/TD]
[TD="class: xl63"]SDC5
[/TD]
[TD="class: xl63"]SDC6
[/TD]
[TD="class: xl63"]SDC7
[/TD]
[TD="class: xl63"]SDC8
[/TD]
[TD="class: xl63"]SDC9
[/TD]
[TD="class: xl63"]Grand Total
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]AEB
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]12
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]AH
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]AS
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]DLV
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]JK
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]6
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]MB
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]12
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]MM
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]SLM
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]8
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]TM
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4
[/TD]
[/TR]
[TR]
[TD="class: xl64"]Grand Total
[/TD]
[TD="class: xl63, align: right"]10
[/TD]
[TD="class: xl63, align: right"]10
[/TD]
[TD="class: xl63, align: right"]1
[/TD]
[TD="class: xl63, align: right"]1
[/TD]
[TD="class: xl63, align: right"]8
[/TD]
[TD="class: xl63, align: right"]5
[/TD]
[TD="class: xl63, align: right"]4
[/TD]
[TD="class: xl63, align: right"]4
[/TD]
[TD="class: xl63, align: right"]3
[/TD]
[TD="class: xl63, align: right"]3
[/TD]
[TD="class: xl63, align: right"]2
[/TD]
[TD="class: xl63, align: right"]1
[/TD]
[TD="class: xl63, align: right"]52
[/TD]
[/TR]
</tbody>[/TABLE]


Then follow these steps
Step 1
At the panel located in the right-side of the window
Uncheck Columns
Drag Values to Row Labels (so you end with Values in Row Labels and in Values area)

Step 2
Filter the second column (Values) to get rid of (empty) values

Step 3
Right-click in the first name (AEB in your data sample)
Pick Field settings
Pick the tab Layout & Print
check Insert blank line after each item label

You get this

[TABLE="width: 143"]
<tbody>[TR]
[TD="class: xl65, width: 91"]Row Labels
[/TD]
[TD="class: xl65, width: 100"]Count of Value
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]AEB
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]12
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]244.9
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]272.4
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]295.90
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]318.0
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]401.9
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]715.96
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]723.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]781.0
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]781.2
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V04.81
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V74.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]AH
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]840.9
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]AS
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]354.0
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]727.41
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.21
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]DLV
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]724.2
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]JK
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]847
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]455.2
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]455.3
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]569.0
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V16.0
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]MB
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]12
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]250.00
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]272.4
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]333.94
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]401.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]414.00
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]562.10
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]600.90
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]729.5
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V12.72
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V16.0
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V76.51
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]MM
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]719.41
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]729.5
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]SLM
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]8
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]244.9
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]296.90
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]304.80
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]493.90
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]959.4
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.21
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V62.84
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V62.85
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]TM
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]340
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]726.2
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]729.89
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]V57.1
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Grand Total
[/TD]
[TD="class: xl65, align: right"]52
[/TD]
[/TR]
</tbody>[/TABLE]


Hope this is what you need

M.

 

[claytont454]

Brilliant! Thank you!!

 

[Marcelo Branco]

Brilliant! Thank you!!

You are welcome and thank you very much for your kind words.

M.