Hello,
I have a fairly simple spreadsheet of population data for a mouse colony.
The layout is simplified as follows:
Column A: Cage number (0001, 0002, etc)
Column B: Females of strain A
Column C: Females of strain B
Column D: Males of strain A
Column E: Males of strain B

There is a bit more information being tracked, and many more strains, but
this is essentially the layout. I am trying to create a second worksheet that
will list information from the main census sheet, but only for breeding
cages. This would be any cage with at least one male and one female. I took
a straightforward approach
=IF(AND(Sum(B2:C2)1,Sum(D2:E2)1),A1)

In terms of presentation, however, this leaves a large number of blank rows,
and makes finding active breeding cages in a large colony difficult. Is there
a way to design a new worksheet that will only contain information from rows
that have a breeding cage?

Thank you