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

LIST function
 

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

LIST function
 

I don't think I expressed my self properly. Its quite confusing if you have
not seen the spreadsheet.

I have a list of students in a column, dates acroos the top of the rows and
in each date is a drop down box for the entries of absencces and type. I
have a summary sheet which simple lists the students and the number iof times
they had each type of absence. What I would like is for each of those
absences a list of only those dates. I have used
=IF(ISTEXT('1A3'!E12),(OFFSET('1A3'!E12,"-2","0")),"") Which brings me back
the cell with the date if there is text in it but I have to do this for each
one and when there is no absence there is just a blank cell. I need to
simple list the dates for the absences in a summary form. I would like it to
update,i.e. should an absence be added not only wil the summary count it but
bring the date up too.

Not sure if I am explaining this very well, but rather than have a summary
sheet which has all the dates with blank cells if no absence I would just
like the list to show the dates there were absences.

Confused? I am!

"Gary''s Student" wrote:

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

LIST function
 

Hi Olivia

Not sure I understand your description. If you want to email me a copy of
your worksheet direct, I will take a look at it for you.

Remove the NOSPAM from my email address to send.

Regards

Roger Govier


Olivia Trimble wrote:
I don't think I expressed my self properly. Its quite confusing if you have
not seen the spreadsheet.

I have a list of students in a column, dates acroos the top of the rows and
in each date is a drop down box for the entries of absencces and type. I
have a summary sheet which simple lists the students and the number iof times
they had each type of absence. What I would like is for each of those
absences a list of only those dates. I have used
=IF(ISTEXT('1A3'!E12),(OFFSET('1A3'!E12,"-2","0")),"") Which brings me back
the cell with the date if there is text in it but I have to do this for each
one and when there is no absence there is just a blank cell. I need to
simple list the dates for the absences in a summary form. I would like it to
update,i.e. should an absence be added not only wil the summary count it but
bring the date up too.

Not sure if I am explaining this very well, but rather than have a summary
sheet which has all the dates with blank cells if no absence I would just
like the list to show the dates there were absences.

Confused? I am!

"Gary''s Student" wrote:


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

LIST function
 

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