(vba) SWAPING THE VALUES FROM THE FREQUENCY REPORT

montecarlo2012

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
984
Office Version
  1. 2010
Platform
  1. Windows
SWAPING THE VALUESFROM THE FREQUENCY REPORT.<o:p></o:p>
Manually I used the frequency function to know whatfrequency every number in every row has.But NOT including the row right above. I mean, the first frequency is B3:G21and the row to be swap is B2:G2.<o:p></o:p>
The row B2:G2 is 1-11-19-33-37-49 so I swap the valuesbase on the range B3:G21; as you see I didn’t included the row B2:G2 at all. Andthe same with the rest. (“note” the RANGE is 18.).<o:p></o:p>
Frequency of the range B4:G22 be compare and swap withthe row B3:G3<o:p></o:p>
Frequency of the range B5:G23 be compare and swap with the row B4:G4<o:p></o:p>
frequency of the range B6:G24 be compare and swap with the row B5.G5<o:p></o:p>
etc, etc, etc, <o:p></o:p>
In other words, every 18 rows take the frequency andcompare with the row right above; I understand the last 18 rows it is notpossible, so until the range match the constrain.<o:p></o:p>
<o:p></o:p>
MY dynamic arrayis at B2:G2064 (the bin is from 1 to 53)and I would like theoutput at K:P.
So the results looks like the images I upload.
Code: 
[TABLE="width: 648"]
<tbody>[TR]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][SIZE=3]swap values[/SIZE]
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][SIZE=3]bin[/SIZE]
[/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][SIZE=3]B3:G21[/SIZE]
[/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][SIZE=3]B4:G22[/SIZE]
[/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][SIZE=3]B5:G23[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]11[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]19[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]33[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]37[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]49[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: #D9D9D9, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl71, bgcolor: #D9D9D9, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]4[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]0[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl72, bgcolor: yellow, align: right"][SIZE=3]1[/SIZE]
[/TD]
[TD="class: xl73, bgcolor: #D9D9D9, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]5[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]6[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]13[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]33[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]35[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]40[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]4[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]3[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]3[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]4[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]4[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]20[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]23[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]26[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]32[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]41[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]46[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]3[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]3[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]3[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]9[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]14[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]17[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]23[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]25[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]29[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]2[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]4[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]5[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]17[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]18[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]24[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]29[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]33[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]4[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]9[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]17[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]21[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]35[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]51[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][SIZE=3]etc. [/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]10[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]12[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]17[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]28[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]38[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]44[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]12[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]14[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]27[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]30[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]36[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]44[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]8[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]7[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]8[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]33[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]35[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]39[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]40[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]1[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]5[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]8[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]39[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]52[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]53[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]6[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]15[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]40[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]45[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]51[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]52[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: yellow, align: right"][SIZE=3]11[/SIZE]
[/TD]
[TD="class: xl73, bgcolor: #D9D9D9, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]14[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]21[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]24[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]32[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]41[/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Tahoma][SIZE=2]45[/SIZE][/FONT]
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]12[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE]
[/TD]
[/TR]
</tbody>[/TABLE]
thanks. <o:p></o:p>
 
Last edited:

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You must log in or register to reply here.

Similar threads

G
  • Question Question
Find Duplicate Values using a Criteria
Replies
2
Views
146
Eric W
Eric W
S
  • Question Question
Unexpected and inconsistent error with ranking rows based on criteria
Replies
2
Views
343
strugglingaccountant
S
M
  • Solved
Looking for a more efficient method for point scoring
Replies
4
Views
167
Kaper
Kaper
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
272
Dan_W
D
A
  • Question Question
VBA to Categorise based on columns
Replies
3
Views
144
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,222,828
Messages
6,168,484
Members
452,193
Latest member
Arlochorim

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