Thread: [Solved] Is there a way to print based on a particular filter?
View Single Post
 
Old 03-15-2012, 09:37 PM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
  
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default
Quote:
Originally Posted by Jamal NUMAN View Post
Is there a way to print based on a particular filter?

I wanted to print in separate pages based on a particular filtered value. For example, in the attached file, I need to print according to the name of the governorate such that the “Bethlehem” governorate is never printed in the same page with next governorate, which is “Hebron” in this case.

I’m used to do this sort of work manually (by making empty rows) but wondering if there is an automated way that helps doing so. please, have a look on the attached screenshots.



the data file is attached.


Thank you for the help,

Best

Jamal
use this select first column named list in b2 kept this formula =INDEX(List,MATCH(0,COUNTIF($b$1:b1,List),0)) with ctrl+shift+enter
Reply With Quote