View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default Need to pull current dates from list w/many dates


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