Hopefully this is aquite a straight forward question:

I have a long list of data for individual companies of which i will be filtering based upon industry groups. I then want to apply functions (finding the correlation between two company variables within a set industry group) to only the filtered results (i.e a specific industry type). At the moment the result of my formula is not affected by any filters placed on the data.

Does anyone know of an easy way to impliment this?

Any input greatly appreciaited,

Regards,
Tom