Hi, I have a column with 1000 data, now i need to count how many of the data are falling within 0-100 , 100-200, 200-300, how can i do that using Pivot table or count function?
Wait online ASAP
Hi, I have a column with 1000 data, now i need to count how many of the data are falling within 0-100 , 100-200, 200-300, how can i do that using Pivot table or count function?
Wait online ASAP
Easiest to show you if you post a sample workbook.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
ok, I want to count how many numbers are between 0 and 100, 100 and 200. 200 and 300 and 300 above.
I'm off to bed soon. There's some good demos here on pivot tables. You can use Grouping to do what you want.
Dom
I've added the pivot table how I think you want it.
Dom
how to setup this in 2007?
how to set up the range in the row label? like <1, 100-199, ...
- Make sure you've got a heading, pivot tables need them
- Select your data and choose Insert...Pivot Table
- Drag the value field into both the Row Labels and Values area
- Double click on Sum Of Values and change it to a Count
- Right click on one of your row labels and select Grouping and specify the start and end values and the interval (by)
Dom
I uploaded the data I need. I need to count based on 0-1million, 1-5 million, 5-10 million and 10-50million and 50million above. the intervals are not same. please help.!!!
Any reason for the gaps and what about the negative values? You can group manually by selecting a range of row labels and then right click and select group. This will let you set up groups of different ranges of values.
Dom
Can you do it for me based on my requirement? I dont know how to manually group them. thanks a lot.
Have you tried? Have a go and if you can't do it I'll have a look in the morning.
Dom
I tried, it s not working for me to manually group them. After I set up intervals at 1,000,000, then I manually group? How to do this?
Have a look at the section here on Grouping Text Items. It's the same principal.
I need similar help. How do I group based on specific groups not uniform as on the summary tab for the pivot table.
And how can I do the same with an actual formula? Counting the occurrence of a number in a range?
See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks