How do you create a list similar to an itunes list?
I am trying to create a list that is similar to how iTunes organizes its music.
I'm trying to create three columns (Year, Film, Director) in excel. That part is easy.
But i want to be able to organize/sort the columns easily.
For instance if I want to view all the rows by year, i would be able to do either ascending or decending. If i want to view all the rows by the the film, i want to view it alphabetically and in reverse. If i want to view the rows by director, i want to view it alphabetically and in reverse.
How do I achieve this with keeping the rows (Year, Film, Director) in tact whenever I switch the ascending/descending ordering of something?
Basically, I want to do an itunes version of a list of movies that can be sorted out easily.
Thank you
|