| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find date query and Display issue
Still working on this one I'm using the below formula in the table (My Reference in Col A and Dates in Row 1 e.g 1/7 to 31/7) to count the references that match each day =SUMPRODUCT(--(July06!$D$2:$D$247<=$B$1)*(July06!$Y$2:$Y$247=$B $1)*(July06!$C$2:$C$247=Sheet2!$A2)) Where B1 = 1/7/06 and so on and A2 to A20 contains my reference. Questions. Can I use this to read data from a closed workbook. How big will it be for 12 months with 20 references. Is this the neatest solution VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561464 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems importing from an Access query | Excel Discussion (Misc queries) | |||
| changing query source | Excel Worksheet Functions | |||
| Microsoft Query editor opens but does not display in excel. | Excel Discussion (Misc queries) | |||
| Formula Help | Excel Worksheet Functions | |||
| How to show query parameters on an Excel page header or worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
