LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formula Not Working with Range with Formulas [email protected] Excel Discussion (Misc queries) 4 February 1st 06 02:01 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Array formula returning wrong results TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 19th 05 10:29 AM
Changing a Formula in Conditional Formatting Dee Excel Worksheet Functions 1 November 2nd 05 04:30 PM
Conditional formula - language needed gamebird Excel Worksheet Functions 7 October 10th 05 11:48 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"