Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting patterns
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. -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=537378 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"&E1,1+MOD(RIGHT(E1),3)) dragged down to the end of your data. filtered by Custom, Does Not Begin with H Hope this helps -- Brisbane Rob Wrote: 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. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=537378 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Dragging a Formula & Basic Setting Changes | Excel Discussion (Misc queries) | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Copying spreadsheet with fonts and patterns | Excel Discussion (Misc queries) |