Thread: Removing Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_30_] Bill[_30_] is offline
external usenet poster
 
Posts: 89
Default Removing Data

Hello,
I have large sets of data where I would like to remove points that are
certain distance from the average. Right now, I go through each cell and
compare that value to the critical value. If it is more than the critical
value, I delete that cell. It takes forever. Is there a quicker way?

Thanks,

Bill