View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
caj caj is offline
external usenet poster
 
Posts: 23
Default Conditional Array Formula for date

I am trying to display all the dates for a particular month from a list. The
data is accumulated on the Log sheet and is pulled to the Monthly Log sheet
based on a dropdown.

=INDEX(Log!$A$1:$O$2000,SMALL(IF((Log!$B$1:$B$2000 <($Q$1),
Log!$b$1:$b$2000($Q$2)),ROW(Log!$A$1:$O$2000)),RO W(Log!2:2)),1)

where
q1 is beginning of month
q2 is end of month

How do I set this formula to just pull dates from the month displayed in the
dropdown.

(I hope this makes sense.)