Restaurant list

**sebthibs** · 07-05-2008, 12:25 PM

Hi,

i started building a list of places i like to go for lunch. I feel though im always going to the same place. So i was wondering if there was a way that excel could suggest me where to go, either randomly, or with some weights on each restaurents. ie lets say i really like burger king, i would assign it a value of 7/10, and mc donalds 4/10, so BK would come up more often than McD

thank you Sebastien

**oldchippy** · 07-05-2008, 12:30 PM

Hi,

Welcome to the forum, take a look here on ranking numbers

http://www.cpearson.com/excel/Rank.aspx

**shg** · 07-05-2008, 02:20 PM

You could do it like this:

Please Login or Register  to view this content.

**sebthibs** · 07-06-2008, 09:17 PM

Thank you very much, its working very well.

i was just wondering if it is possible to put a button that would generate the results?

**shg** · 07-08-2008, 01:27 PM

Just push F9 to see a new result.

**martindwilson** · 05-27-2011, 05:19 AM

this has got to be the most tenuous spam post ever lol

**Cutter** · 05-27-2011, 08:46 AM

Is that how Directed Advertising works?

Find a person in Montreal, Canada who can't spell restaurant and who, 3 years ago, preferred eating at Burger King over McDonalds (so presumably a beef eater), and provide restaurant choices offering "fine dining" located in Delhi, India.

Seems a little off-target.

EDIT: Now that the title has been changed from "Restaurent List" to "Restaurant List" the "who can't spell restaurant" makes no sense!