Setting patterns

You could use a helper column that uses the criteria to determine that the row should be hidden or printed and Filter on the non-hidden rows.

Such a formula could be (say) testing column B, set in column E, set 1 in E1, and in E2 the formula:

=IF(B2="NO","H"&right(E1,1),1+MOD(RIGHT(E1,1),3))

dragged down to the end of your data.

filtered by Custom, Does Not Begin with H

Hope this helps

--

Originally Posted by Brisbane Rob

I have to regularly print a three page list and I set a pattern on every third row to make it easier to read across the page. Now I want to filter it so only rows which meet certain criteria are shown and some will be hidden. This upsets the 'every third row' concept.

Any ideas on how I can achieve this?

Thanks.