I need to sort an excel spreadsheet (list of customers & locations) into 3 separate random lists (for survey)?

On my excel spreadsheet I have about 400 Company names listed in the rows and as columns have their city, state, zip, etc. I need to sort the data so that every 3rd contact (or row) is somehow exported or separated from the others. I have 3 people who will be using the lists to conduct a market survey and need the random sort so that it is statistically accurate and fair. PLEASE any suggestions are appreciated. It is Excel 2003 and I've already searched the microsoft help page and the internet for help!

I need to sort an excel spreadsheet (list of customers %26amp; locations) into 3 separate random lists (for survey)?
Designate a column and fill it with this formula:


=RAND()


Then sort by that column. This is outside of your "every 3rd" criteria, but you can give third of the list to a person.
Reply:LOL, Michael B got there first! Perfect.
Reply:insert a column in front of the business name column. In the first cell of the new column enter "=RAND" then fill down to the last entry. Highlight that column and select copy. Then rehighlight the column and select paste special. Select "values" as the thing to be pasted. If you don't use paste special, the random numbers will be resampled everytime u try to sort and will make the numbers difficult to reproduce or can get messed up easily. once it is pasted. highlight the entire spreadsheet and click on sort. This basically assigns each item a random number then rearranges them according to those random numbers.

Would you please take another survey?

1. Do you prefer apples or bananas? Why?


2. Do you have a flip phone or some other kind of cell phone? Why?


3. Would you rather have a customer service representative who is nice but doesn't know anything or one who is brusque and knows the answer to your questions? Why?


4. Is there anything more annoying then someone who asks "Why?" all the time? Why?





Thank you for answering Dragon's survey. ♥

Would you please take another survey?
I certainly would take another survey.





1. Bananas. Though I like the taste of apples better, my doctor recommends potassium %26amp; bananas meet that need.


2. I have a flip phone because it's easier to fit in pocket %26amp; purse.


3. I'd rather have brusque %26amp; knowledgable so my issues get addressed more efficiently.


4. I surely hope not because I ask 'why' almost all the time.





Thank you for posing this survey, Dragon.
Reply:Gypsy loves Dragon too. Thank you %26amp; have a super day. Beware those knights with ketsup bottles on hand. Those are not Dragon's friends. Torch first %26amp; ask questions later. ;) Report Abuse

Reply:Bananas... they satiate my primal instincts.





Flip Samsung Phone... because it was a present from my husband.





One who is brusque and knows the answer to my question because i can't stand it when i don't get things that are important done.





Yes. Someone that doesn't question at all is much more annoying. I can't stand people that are too scared or too arrogant to ask questions. It's not possible to know everything. But it is possible to know absolutely nothing. At least you can TRY!
Reply:apples im sick of allways eating bananas


Flip phone i don't know why


someone who is brusque and knows the answer


yes two little siblings who ask WHY? alllllllllllllllllllllllllllllllllllll the time!
Reply:WHY?
Reply:I like bananas better because easier to eat on the run, I have a flip phone, just because I think they're cool, I would want someone to answer my questions, because I wouldn't ask questions if I already knew the answer or knew what I was doing. Most of the time people that ask why all the time are annoying, but Dragon's got pretty shinny teeth and I wouldn't want to upset her, so Dragon's "why" questions don't bother me,





Anytime, I like Dragon's survey!
Reply:Is or Is not, there is no Why.
Reply:Bananas. Easier to eat.


RegulAr cell. Works for me.


One's whos nice. They are trying to learn.


Maybe. Sometimes an explanation is not needed.
Reply:YOU ARE AS BORING AS A THREE YEAR OLD.


WHY WHY WHY WHY WGY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY WHY?


WAS THIS BORING?OR ANNOYING?


AND IF SO WHY?


And if not:WHY not?
Reply:1.bananas, they taste better


2.flip phone, because I do


3.brusque, I can get my answers


4.no, because
Reply:It is too much to answer ,OH
Reply:1bananas they get me going in the morning and last until lunch


2yes i have no other way of getting in touch with anyone save my work computer


3brusque and informative i could care less for peoples attitudes towards me because as soon as i am done with them it doesn't matter


4yes a person who does anything it doesn't matter how subtle just to piss you off because it's gonna piss you off and make the other person happy. the only way around it is to destroy everything involved house table people whatever it's just the only way
Reply:bananas. Apple peels get stuck in my teeth


I dont have a cell, my dog chewed it up.


Someone who is nice. I hate talking to rude people, it ruins my day.


No! You have to learn somehow, righ?
Reply:1.Bananas, I like their consistency.


2.Flip phone because it was free w/ the plan.


3.The one who knows the answers because that's what I'm there for.


4.No, and because.
Reply:oranges


rotary dial phone


I once ate a worm, it tasted like dirt


I have to pee.
Reply:1. I love the bananas. They just taste better to me.


2. I have a nokia not a flip phone because I got it free with my


contract.


3.I will take a rude customer service person who knows their stuff over a nice unknowledgable one anyday.


4. My son asks me questions everytime he opens his mouth and has since he is little, he is now 16. Why questions don't bother me at all.


Have a great day, Dragon :)

Do you think Pizza Hut puts too little, just right, or too much sauce on pan pizzas - AboutPizza.com Survey?

This is for an informal survey I am doing for the AboutPizza.com web site. Many customers complain the suace cooks into the dough and Pizza Hut does not take this into account when deciding how much pizza sauce to put on a pan pizza. Of course some customers don't like too much sauce on pizza so I think we need to find out what people really think.

Do you think Pizza Hut puts too little, just right, or too much sauce on pan pizzas - AboutPizza.com Survey?
It really does depend on the individual store but for the most part too little. However, if you tell them you want extra sauce they usually comply.
Reply:Oh, Goodness they put just the right amount of sauce..... You arent living unless youve tried that pan pizza Report Abuse

Reply:I say too little...
Reply:Too little. That's why I don't eat there.
Reply:definitely too little....I even order extra sauce when I put the order in.
Reply:not enough
Reply:The sauce ratio seem OK to me, but the pizza (sauce included) is way way way too salty.
Reply:too little
Reply:I think it's perfect. The only thing that makes Pizza Hut's pan pizza better is to dip it in freshly made ranch dressing.
Reply:enough. I don't like to much.

Just wondering to know what kinds of items a foreigner will buy if he visits to China?

I would like to do a survey about items or goods customers from the USA or Canada would be interested to purchase from China.

Just wondering to know what kinds of items a foreigner will buy if he visits to China?
I prefer products made here (USA).
Reply:Sweet and Sour Pork, Pot Stickers, Egg Foo Young, and a bunch of Fortune Cookies, but only buy the ones with good fortunes...there are just too many bad fortunes out there right now.
Reply:Ahh,i love the answer posted by last visitor. China is an amazing country, their arts and crafts are pretty cool and there is no other choice you should buy for your friends or relatives. i usually make a purchase from Ebay, you can always find some good items from China sellers. Try to get the same experiences as me, you will be not disappointed. LOL
Reply:I spent 2 months in China for an interniship in 2004. One of my favorite things to do after classes was to go to the night markets in Hangzhou. Most of the things I bought were souvenirs for friends and family. I did purchase a lot of household/decorating things: scrolls, chopstick sets, decorative fans, etc. I also bought traditional clothes, scarves, and jewelry. And I always tried to buy at least one trinket or something from each of the temples or palaces I visited as a way to remember the trip better.

roller blades

Market Survey - What are the special things you want in your Soap and cosmetics?

Customer complaints and ideas are Welcome.





"Quality is our motta"

Market Survey - What are the special things you want in your Soap and cosmetics?
i wish my cosmetics were good for me. like not only do they make me look and feel great, its also good for me. like mega vitamin, hydrating, anti-aging, firming, undo-damage kinda product.
Reply:What ???

Can you help me in that survey?its really important for me,really?

for the coming points what do you think is necessary for you to find in Automotive engineering Department


For each item identified below, circle the number


to the right that best fits your judgment of its needs.


Use the scale above to select the quality number.


Customer VoiceScale


Not important (1) , Slightly important (2) , Neutral (3), Important (4) , Extremly important (5)





1.Prefer that they be well trained before graduation. 12345


2.Prefer have idea in management not only engineering. 12345


3.Should have a fair knowledge about statistics and statistical knowledge.12345


4.Speak English Fluently.12345


5.Study engineering and business ethics12345


6.Know international and national business.12345


7.Should have Maintenance Knowledge 12345


8.Study design of computerized line of assembly systems. 12345


9.Know technology of painting.12345


10.Know techniques of car testing.12345


11.Know the design of data base and information system. 12345





please say ur gender age Job

Can you help me in that survey?its really important for me,really?
1. 4


2. 5


3. 3


4. 4


5. 4


6. 3


7. 5


8. 5


9. 4


10. 5


11. 4





m, 24, communications officer
Reply:1.4


2,2


3.3


4.4


5.4


6.2


7.5


8.5


9.4


10.5


11.4





age 33/f/science teacher

Makeup Question

Help me understand how to make a eqation out of story problem please?

In most businesses, increasing prices of their product can have a negative effect on the number of customers of the business. A bus company in a small town has an average number of riders of 1,000 per day. The bus company charges $2.00 for a ride. They conducted a survey of their customers and found that they will lose approximately 50 customers per day for each $.25 increase in fare.


The bus company has determined that even if they set the price very low, there is a maximum number of riders permitted each day. If the price is $0 (free), how many riders are permitted each day?


Answer:





Show work in this space:





c) If the bus company sets the price too high, no one will be willing to ride the bus. Beginning at what ticket price will no one be willing to ride the bus?





Answer:





Show work in this space:

Help me understand how to make a eqation out of story problem please?
First of all you have to make the wide-sweeping assumption that the number of customers lost or gained is a linear function of the price. Assuming this...





You need to find a function R = f(P), where P is the price and R is the number of riders. You have one point, namely (P,R) = (2.00, 1000). Assume that f(P) = mP+b, as is usual for a linear function. Then





1000 = m(2)+b





You are given that if P is increased by 0.25, then R is decreased by 50. This means that another point is given by (P,R) = (2.00+0.25,1000-50) = (2.25,950). So





950 = m(2.25) + b





Solve these two equations for m and b. Do this yourself before continuing to read. You should get:





R = 1400-200P.





The first question can't be answered. Sure, you can plug in 0 for P and get R = 1400, but how do you know they don't permit, say, only 1300 riders? The problem does not say. If so, the answer is not 1400, but 1300.





To answer the second question, labeled c), you need to substitute 0 for R and solve for P. You should get P = $7. Would you pay $7 for a bus fare? I wouldn't.
Reply:One hazy morning a telephone started ringing in an office of Mark Ignashin, an investigator with the prosecutor’s office of Tula’s central district. “This is a duty officer of a district police station. We’ve received a report on a mummified body found in apartment building No 142 on Lenin Street. We’re sending a vehicle to pick you up, Mr. Ignashin,” said the officer and hung up.
Reply:If an increase of 25 cents causes 50 people to stop riding, then a decrease of 25 cents should cause 50 more people to ride. Therefore, you need to find out how many more people will ride when you decrease it by 200 cents.


200/25 = 8, so a decrease of the fare to nothing will mean 8 reductions of 25 cents, and 8 *50 people will start riding. In other words, it is 200 * (50 / 25) more people, or 400 more people, for a total of 1400 people.








The rate of change of people per cent increase is


(- 50 people) / (25 cents) = -2 (people / cent)


If we want the number of people to be zero, divide the number of more people you want to start riding the bus by this rate, and you will get a value in cents. Since you want to find when 1000 people stop riding the bus, you need to use -1000, or a decrease of 1000 people, for the number of people.


Then 1000/2 = 500, or 500 cents, which is 5 dollars more, or 7 dollars.