98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel count data
Excel count data
Resolved · Urgent Priority · Version 2003
Thu 26 Feb 2009, 16:51Delegate Chrisa said...
Chrisa has attended:
Excel Advanced course
Excel count data
I have a list of post codes with counts of people in them, but I want all the individual people's post codes in one column. Some counts contain more than 500 or even 1,000 counts, so it is not easy to copy paste them in the same column. Does anyone know of an easy way of doing this?
Thanks!!
Fri 27 Feb 2009, 13:12Trainer Amanda said...
RE: Excel count data
Hello Chrisa
Thank you for your question.
How are the post codes stored currently? I'm assuming they are in a column with other data if you want to separate them out?
Kind regards
Amanda
Fri 27 Feb 2009, 13:17Delegate Chrisa said...
RE: Excel count data
Hi Amanda,
The post codes are in one column and the person counts in a second column next to the post codes. What I want is all the post codes in one column, for instance if a post code had 40 counts, I want that post code 40 times in the post code column. Some post codes have 1,000 counts so it is tedious to do it manually. :)
I hope this makes sense.
Thanks,
Chrisa
Fri 27 Feb 2009, 13:33Trainer Amanda said...
RE: Excel count data
Hello Chrisa
To my knowledge, there is nothing in 'standard' Excel that would do this for you. It sounds like something that may be achievable using VBA. I will look further to see if there is maybe a function that would help, but I'm not sure that I'll find anything useful.
Kind regards
Amanda
Wed 15 Apr 2009, 16:49Trainer Rajeev said...
RE: Excel count data
Dear Chrisa
I would be interested in getting a small version of this file to play around with it . Unfortunately I can't visualise this clearly in my head.
Even if it means you can make u some dummy data may be not 10000 records but about 5 to 10 records and have it the same layout as you have in your spreadsheet. Please e-mail it to me on rajeev@stl-training.co.uk and I'll definitely look at it and try to provide you with the more relevant answer.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Thu 14 May 2009, 10:15Trainer Rich said...
RE: Excel count data
Hi Chrisa,
How did you get on with this one?
Have you e-mailed a copy of your workbook, or dummy example, to Rajeev?
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
Wed 20 May 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |
