If your songs are only introduced on one day each week you could create
a new column.
=if(match(date you are interested in,c2:x2,0)0,1,0) should create a
column of 1's and 0's that can be sorted or filtered
if you enter the date in a single cell eg a1
=if(match($a$1,c2:x2,0)0,1,0)
should suffice
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=513718