You could apply a filter (Data, Filter, AutoFilter) and then have your filter
show everything that does not equal FALSE. (under custom)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kiley" wrote:

I have created the following "IF" formula =IF('officer
data'!Z4="fse",'officer data'!A4) to pull employees that have a status of
"fse" from another worksheet in the same workbook. I only want to show the
rows that are "TRUE" and automatically hide rows that are "FALSE"