=IF(yourexpression=TRUE, yourexpression, "")
--
Gary's Student


"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!!!!