|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Excel Formulas
Hi ,
Take a look to Debra web
http://www.contextures.com/xlDataVal02.html#TwoWord
"djs" wrote:
I need some help.
Ive got a very large woork sheet and would like ot break it down so I dont
have to do alot of typing. Here is what I would like to know if its possible.
1. Ive created a number of Dropdown list, but wanted to know if when I
selected a particular item from from list in cell B2 cell D2 would
automatically be populated by the correct list? e.g. Department Heads are
selected in B2 only the pre-assinged names would appear in a drop down list
in cell D2. and so forth.
2. How do I do a sort by text or would I need to put a number infront of the
text for it to work. eg. Say I had a sheet of 1000 employess by department,
positions,yrs of service and so on. How could I sort out only the Department
Heads or say job lvls?
Ive tried many different formulas but they would work for part but not all.
Help would be greatly appreciated.
|