Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Here is what i got: a6 =IF(ISERROR(VLOOKUP($D$4,Functions!$B2:$L$100,1,FA LSE)),"",VLOOKUP($D$4,Functions!$B2:$L$100,1,FALSE )) a7 =IF(ISERROR(VLOOKUP($D$4,Functions!$B3:$L$100,1,FA LSE)),"",VLOOKUP($D$4,Functions!$B3:$L$100,1,FALSE )) and so on, the only change is the lookup area reduces by 1. d4 is a month number (1-12) based on the current month. oct=10 nov=11 etc.. Functions!B3= Month number for jobs, so there could be 12 jobs for October. a6:a100 is adv. filtered by D4. OK, here is my problem, the way the fromulas are in a6:a100 i get the same result on descending lines. example- a7: 10 Job 3 October 5, 2004 a8: 10 Job 3 October 5, 2004 How can I fix this to get all the results for October without repeating? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=473033 |