Thread: LIST function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Olivia Trimble
 
Posts: n/a
Default 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!!!!