In a separate column to the right, I would write a flagging formula such
as:

=IF(AND(A1="GTO",TEXT(B1,"mmm")="Feb"),"Y","N")

Then you can use filter buttons at the top to filter for the Y's. My
formula assumes that you are looking for all February entries and
column B is formated as a date.


--
bakes1
------------------------------------------------------------------------
bakes1's Profile: http://www.excelforum.com/member.php...o&userid=31965
View this thread: http://www.excelforum.com/showthread...hreadid=517988