[TABLE="width: 50"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]USE
[/TD]
[TD]102.56%
[/TD]
[/TR]
[TR]
[TD]USE
[/TD]
[TD]87.34%
[/TD]
[/TR]
[TR]
[TD]USE
[/TD]
[TD]72.56%
[/TD]
[/TR]
[TR]
[TD]FIN
[/TD]
[TD]86.5%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]90.56%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]70.45%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]69.67%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]68.45%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]75.56%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]65.12%
[/TD]
[/TR]
</tbody>[/TABLE]
Hi All , In vba I'm trying to find the best way to be able to extract the top 4 percentages (and average them) for each of the groups in col A. an then paste the average and Group code to another sheet in order. anyone an good idea how to go about it?
thanks
Dan
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]USE
[/TD]
[TD]102.56%
[/TD]
[/TR]
[TR]
[TD]USE
[/TD]
[TD]87.34%
[/TD]
[/TR]
[TR]
[TD]USE
[/TD]
[TD]72.56%
[/TD]
[/TR]
[TR]
[TD]FIN
[/TD]
[TD]86.5%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]90.56%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]70.45%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]69.67%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]68.45%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]75.56%
[/TD]
[/TR]
[TR]
[TD]BAE
[/TD]
[TD]65.12%
[/TD]
[/TR]
</tbody>[/TABLE]
Hi All , In vba I'm trying to find the best way to be able to extract the top 4 percentages (and average them) for each of the groups in col A. an then paste the average and Group code to another sheet in order. anyone an good idea how to go about it?
thanks
Dan