| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down menus
is there any way to use functions (lookup, count if, etc) based on the
value in a drop down menu? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menus
sk1951, with what you want to count in a drop down in A1 and the range you
want to count in B1:B10 =COUNTIF(B1:B10,A1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "sk1951" wrote in message oups.com... is there any way to use functions (lookup, count if, etc) based on the value in a drop down menu? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down menus | Excel Discussion (Misc queries) | |||
| formulas for drop down menus | Excel Discussion (Misc queries) | |||
| how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
| Drop Down Menu's | Excel Discussion (Misc queries) | |||
| Drop down menus | Excel Discussion (Misc queries) | |||
Linear Mode
