Saladsamurai
09-21-2009, 11:53 AM
Okay then :)
I have attached a sample WorkSheet, though it's probably not necessary.
The sheet has a bunch of cells (duh...) that contain either a "$" or a "c" or a number as a Percentage.
I would like to write a code that Loops through the Range and puts the percentages into Classes, like for a Histogram.
I would like to store the frequency of each class in a variable.
The classes can be as simple as:
Over_90 = # of times >= 90%
From_80to90 = # of times from 80% to 90%
From_70to80 = # of times from 70% to 80%
Under_70 = # of times < 70 %
I was going to use a Nested For-Loop with a Select Case inside of it.
But I was not sure if there was a FASTER/More Efficient way then Looping
Thanks!!
I have attached a sample WorkSheet, though it's probably not necessary.
The sheet has a bunch of cells (duh...) that contain either a "$" or a "c" or a number as a Percentage.
I would like to write a code that Loops through the Range and puts the percentages into Classes, like for a Histogram.
I would like to store the frequency of each class in a variable.
The classes can be as simple as:
Over_90 = # of times >= 90%
From_80to90 = # of times from 80% to 90%
From_70to80 = # of times from 70% to 80%
Under_70 = # of times < 70 %
I was going to use a Nested For-Loop with a Select Case inside of it.
But I was not sure if there was a FASTER/More Efficient way then Looping
Thanks!!