If your expression yields a column of TRUE's and FALSE's, then filter on the
TRUE's.

"Olivia Trimble" wrote:

I am trying to list only the cells which have returned TRUE to the IF
function I have put in. i.e. I want it to only show these in adjacent cells
and automatically change if the data should be updated. I'm not even sure
Excel can do such a thing but maybe there is a function to automatically hide
cells if they have not returned true to the functions in them.

Help!!!!