Is there a function or formula that can filter other cells? I have a sheet that has averages of different variables of data on another sheet. Now, I am having to input the averages by hand because some of the other values are “NaN.” In other words, I filter out NaN’s on certain columns and generate values that I need. Is there a way that I can write a function that can call a filter, and then do some computing? Or, is there a more logical program to use than Excel? I tried to explain this, the best I could, but if there are any questions please ask. I am having a hard time researching this on my own.