LIST function
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!!!!
|