Hey Folks,
any Excel experts around? Not sure where to start with that problem:
Got a list of bands in different columns ("Alcest" actually starting in C9, the last current entry is somewhere in AQ 16). There are only 8 lines in each column, sometimes the last or last two lines in a column are empty
What i want to have, is a list/chart/image/whatsever how often every band is named in those columns sorted by how often. So the output should be something like
(3 times) Amplifier
(2 times) Airbag
(2 times) Gazpacho
(2 times) Periphery
...
..
(1 times) Textures
Any idea how i can get that result. Could be a nice diagram as well ....
Thx a lot
R.
any Excel experts around? Not sure where to start with that problem:
Got a list of bands in different columns ("Alcest" actually starting in C9, the last current entry is somewhere in AQ 16). There are only 8 lines in each column, sometimes the last or last two lines in a column are empty
PHP Code:
Alcest Amplifier Airbag Airbag
Anathema Archive Alamaailman Amplifier
Crippled Black Phoenix Devin Townshend Amplifier Beardfish
Flying Colors Elbow Daedalus Gazpacho
Gazpacho Haken Gran Torino Jane
Leprous Moonspell Jolly Opeth
Pain of Salvation Periphery Panzerballet Overhead
Periphery Textures ---------- Renaissance
(3 times) Amplifier
(2 times) Airbag
(2 times) Gazpacho
(2 times) Periphery
...
..
(1 times) Textures
Any idea how i can get that result. Could be a nice diagram as well ....
Thx a lot
R.
Comment