Excel Formulas

  • Thread starter Thread starter djs
  • Start date Start date
D

djs

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.
 
Debra Dalgleish shows how you can achieve your first requirement here:

http://www.contextures.com/xlDataVal02.html

As for your second query, have you tried highlighting the data and
using Data | Sort ? You can sort on up to 3 fields of data (columns)
and choose ascending/descending order for each of those fields.

Hope this helps.

Pete
 
It worked great Eduardo and Pete. Thanks alot for the tips.

I just have one more question: How can I make it that when I select
something from a drop down list in B2 Cell D2 would have the correct answer.
e.g. A2 - Dept. Heads is selected from list. B2 - Production. C2 would have
the name of the production Manager.

Hope someone can help me with this one.

djs...
 
Debra's site also shows how you can have a third dependent drop-down,
but if you only have one Production Manager then you can use VLOOKUP -
Debra gives full details on her site.

Hope this helps.

Pete
 
Back
Top