Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
Conditional formula - language needed | Excel Worksheet Functions |