How to use Pivot table or some function else in Excel to find out matched data according to predefined rules?

Hi Pros,

I have a table of data and a list of rules that I need to find out the matching data from the table according to the rules. For example, one of the rules is to find out one or more transactions totalling certain amount in a month. or pick out the transactions happened in certain countries of which totaled certain amount.



Thanks so much for your help.How to use Pivot table or some function else in Excel to find out matched data according to predefined rules?
You can use filters or Category summary........How to use Pivot table or some function else in Excel to find out matched data according to predefined rules?
I would suggest using the Auto-filter feature and maybe the SUBTOTAL function



Autofilter tutorials

http://video.google.com/videosearch?hl=e鈥?/a>



Subtotal tutorials

http://video.google.com/videosearch?rlz=鈥?/a>



You could use a Pivot Table. Just web search ';Excel pivot table tutorials'; to get a lot of good step-by-step guides.
i try to write the answers your problem in my blog http://www.mystructuredsettlement.co.cc you can see any problem in my blog or in my business blog http://www.mysecuredloan.co.cc