I have a worksheet containing data, the fields include a list of categories, say dog, cat, rabbit; and for each of the records listed their age is stored in a field.
Can I produce a pivot table showing the number of dogs with an age greater than X?
I have a worksheet containing data, the fields include a list of categories, say dog, cat, rabbit; and for each of the records listed their age is stored in a field.
Can I produce a pivot table showing the number of dogs with an age greater than X?
Yes - should be easy. Please post an example spreadsheet, showing how your Pivot table and data are arranged (NOT a screen shot, please!!).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I don't see a Pivot Table really being needed with data that are not too complex in their structure. Does this work?
But if you realldo want a Pivot Table (perhaps your dataset is much more complicated) then look a few rows further down in the attachment.
Last edited by Glenn Kennedy; 05-18-2014 at 03:34 AM.
Thanks for this. Yes my data is much more complicated 30K rows and 100 'species'. I've 'twisted' your solution to fit my purposes. Can you tell me how you created the 'species' filter please.
<Apologies I've just worked out that last piece. Thanks>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks