I wonder if any of you experts can help. I'm entirely self taught excel user, and so you'll need to speak slowly!
I have some data showing land ownership (in acres) and social group, by household. I want to 'group' the land data - so that instead of showing the actual amount that each household has I put them into groups - ie 0, 0.1 to 2 acres, 2.1 to 5 acres etc). Do I do this in a pivot table (and if so, how?!), or do I have to create a new column in my data sheet, and find a way of putting the acreage data into groups?
Thanks for your help! I'd found my way to the same page, and it seems that while this is one way of doing it... there is another way. I've ended up 'grouping' data in a pivot table. (Much better - as this isn't a one-off!) Haven't quite got there, as the groups have to be the same distance apart (if that makes sense) - but at least I'm on the right lines! madcows