Rating System

[Drewmyster]

Hi there, I've a databse of music, songs, artists and albums, and I want to be able to rate them using a "star" system like that used in such programs as iTunes.

Can this be done and how?

Regards.

 

[cbzdmh]

Cant you just pick rating from a drop down box?

 

[Drewmyster]

Explain how please.

 

[cbzdmh]

In part of the sheet you're not going to use type the values you want to be able to select.

For example using column C

C1 - "Awesome"
C2 - "Good"
C3 - "Average"
C4 - "Poor"
C5 - "Wish I was deaf"

For all the cells you want to turn into a drop down menu, hen go to the data menu and select validation.

One of the options will be "List", then select the cells you just typed into.

http://www.youtube.com/watch?v=SzvDL9PZs1w

 

[rpaulson]

cbzdmh,

I just found that you don't need to put the values in cells. You can just go to data validation - List and enter them into the source box separated by a comma

Awesome,Good,Average,Poor,Wish I was deaf

then copy cell as needed.