Office & Productivity Software forum

General discussion

sorting numbers in Microsoft Excel 2003

by Kelray / December 13, 2007 2:49 AM PST

I have Microsoft Excel 2003 on my computer. My wife is selling raffle tickets for a fund raiser for school. She wants to put all the ticket numbers and the buyer's information into a spreadsheet that she can print out after all the tickets are sold. I can set up Excel to put in all that information, but there is one thing I want to do that I can not figure out how to. I want to be able to put the tickets in as I get to them and then have Excel sort the numbers so they are in order. I hope this makes sense to you. Thank you in advance for any advice you can offer me.

Post a reply
Discussion is locked
You are posting a reply to: sorting numbers in Microsoft Excel 2003
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: sorting numbers in Microsoft Excel 2003
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
What I would do.
by MarkFlax Forum moderator / December 13, 2007 4:32 AM PST

May not be the best or the most economic way, (in my own time), but I would input all the raffle ticket numbers first. That way there is no sorting to do.

In a column next to each entry I would input "Not sold".

Then, as each ticket is sold I would change the corresponding "Not sold" to whatever details are needed.

It would need dressing up a bit, but with that I could print out a list of it all, showing tickets sold and tickets not sold.

Or am I missing something?

Mark

Collapse -
Time not an issue
by entrecon / December 13, 2007 11:21 PM PST
In reply to: What I would do.

Most raffle ticket numbers run in order so you could just enter the first 2 numbers (i.e. 24000 and 24001) and then do an Autofill for the total number of tickets. Should just take a couple of seconed to do. You could also autofill the "Not Sold" column pretty quick.

Collapse -
Re: sorting in Excel
by Kees Bakker / December 13, 2007 6:33 AM PST

I don't see why you couldn't use the normal Data>Sort menu options. Can you explain?

Kees

Collapse -
Just guessing..
by entrecon / December 13, 2007 11:19 PM PST
In reply to: Re: sorting in Excel

but maybe the user isn't aware of the Sort function. The only other thing I can think of is perhaps they are also entering ranges in the ticket number field for people that buy multiple tickets (i.e. 24000-240009 & 240011). This would end up sorting numbers and text with the ranges ending up at the end of the list.

One little warning when using the sort function, make sure you don't have just the column with the numbers selected or you will end up sorting ONLY that column and everything else will stay in its original location.

Out of curiosity, why do you need to know who purchased every ticket? This seems like quite a bit of work. Wouldn't you just want to enter the contact information for the winners? If you are looking to create a mailing list, the ticket numbers wouldn't matter and you would only need to enter a person's name once instead of multiple times if they buy mutliple tickets.

Collapse -
Sorting Function
by Kelray / December 16, 2007 3:06 AM PST
In reply to: Just guessing..

I am very new to the use of Microsoft Excel 2003. I don't know anything about the sorting function. I will have to investigate it. The reason we want to put all the contact information into the spreadsheet is so that we can print it when we are done and take it with us to where the tickets are being drawn. That way as the tickets are drawn we can look at the list and find out who the winners are. I thought about just listing the numbers in order down the side, but then with every ticket you have find the number of the column before you fill in the information. If I could just enter the information as I go not worrying about what order the numbers are in and have Excel sort the numbers afterword it would make it much easier. I hope that explains what I am trying to do.

Collapse -
Link, comment
by Kees Bakker / December 16, 2007 3:28 AM PST
In reply to: Sorting Function
Collapse -
Not on the Ticket...
by entrecon / December 17, 2007 2:49 AM PST
In reply to: Sorting Function

You don't have the person's name on the ticket when it is drawn? Most raffles I have been in have me put my name and information on the ticket to be drawn.

In Michigan we have very strict rules in raffles, what tickets can look like, how they are drawn, etc. So maybe rules are different where your raffle is being run.

Popular Forums
icon
Computer Help 49,613 discussions
icon
Computer Newbies 10,349 discussions
icon
Laptops 19,436 discussions
icon
Security 30,426 discussions
icon
TVs & Home Theaters 20,308 discussions
icon
Windows 10 360 discussions
icon
Phones 15,802 discussions
icon
Windows 7 7,351 discussions
icon
Networking & Wireless 14,641 discussions

Tech explained

Do you know what an OLED TV is?

CNET explains how OLED technology differs from regular TVs, and what you need to know to make the right shopping decision.