| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down FIlters.
Hi I have a complex question. I need: A drop down box with the months Jan- December (i have this sorted) I need this drop down box and whatever month is in it to look at another worksheet, here it must look for all entries in January for example. When it has found these entries i need it to count the number of 'passes' that occur in row 4 of a sheet. I have tried using DSUM but am not completely sure how to use it in this scenario. I have no idea how to combat this problem and hope i have explained above. Thanks in advance -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=529614 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| formulas for drop down menus | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Threaded Mode
