Thread: Array to find rows need to insert date criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel 2003 - SPB Excel 2003 - SPB is offline
external usenet poster
  
Posts: 26
Default Array to find rows need to insert date criteria
How do I include a date limitation for a selected month into this array, the
date column is €śC€ť the date is in J4 enters as 8/1/07
This returns the correct row numbers

=SMALL(IF(Data!$AE$2:Data!$AE$30000,ROW(Data!$AE$ 2:Data!$AE$3000)),ROW(1:1))


=SMALL(IF(Data!$AE$2:Data!$AE$30000,ROW(Data!$AE$ 2:Data!$AE$3000)*MONTH(Data!$C$2:Data!$C$3000=MONT H($J$4))),ROW(1:1))

Thanks SPB

Reply With QuoteReply With Quote