I need to screen out high and low values from a data set that contains any
number of columns. The first column contains the time stamps and the
remaining columns contain the data. I currently put the raw data into an
array and then create an array of the screened values (i.e., data that meets
the criteria) which is displayed on a worksheet. The data that is screened
out is replaced with empty cells or null values (""). This process works
well but performance is an issue.

Does anyone have any suggestions on how to improve the performance? I'm
currently looping through the data and using IF THEN statements to make
decisions. It would be ideal if this could be done using some sort of array
commands.

Thanks in advance,
Raul

Can you post what you are currently using?

"Raul" wrote:

I need to screen out high and low values from a data set that contains any
number of columns. The first column contains the time stamps and the
remaining columns contain the data. I currently put the raw data into an
array and then create an array of the screened values (i.e., data that meets
the criteria) which is displayed on a worksheet. The data that is screened
out is replaced with empty cells or null values (""). This process works
well but performance is an issue.

Does anyone have any suggestions on how to improve the performance? I'm
currently looping through the data and using IF THEN statements to make
decisions. It would be ideal if this could be done using some sort of array
commands.

Thanks in advance,
Raul