Can I filter out just part of a row?

[HelenW01]

I have a simple list report which has rows of jobs and corresponding data. Some of the data is many to one and only want to show it if it meets a certain criteria but I cannot work out how to do this. I have tried making all the relevant data null if the criteria is not met but this has led to 6 or more rows of blanks of nulls being inserted. Is there any way to get around this?

 

[drlex]

Helen,
Are you using conditional formatting to hide the unwanted rows?


soi la, soi carré

 

[HelenW01]

Thank you for that suggestion, I hadn't thought of usomg conditional formatting