Perhaps you want to filter the data so only the appropriate row shows? Advanced Filters?

We need a sample workbook to see exactly what you mean when you say "Display Both".