I have three columns with repeated values in each that I am using to create
dependent drop down lists using data validation in excel.
Because of the repeated values in each column (not just the first one), I'm
having trouble getting the drop down lists to display only pertinent

I have a spreadsheet with 6 drop down boxes. Is there away to make the
dropdown boxes in a specific default every time another user opens it?

I am working on a spreadsheet for workers comp injuries.  I need to have a
total of injuries broken out per year.  I can't seem to get the function to
work properly...probably because I am using the wrong one.  Any ideas?

Currently, I have an excel spreadsheet that looks like this:
A                                              B
                     C
Pamela Potter                  Kris Sautter        Anita Serda

I have a dropdown validation list. When I select an item from this
list, the rows below will be populated using the HLOOKUP function. The
HLOOKUP function brings the values from the other sheet. The records
will be one to one thousand. And I have the formula upto 1000 rows.

Is there a worksheet function that will return the status of the worksheet as
being "protected" or "unprotected" that I can display?
Thanks for any and all assistance.
JimB

I am trying to write a formula that is contingent on an adjacent column.  
Specifically, I am writing a formula using multiple IF worksheet functions.  
In an adjacent column I have a series of 1's and 0's with non-blank cells in
between.  Does anyone know how to write a formula ...

This forum has helped me so much a nubie at 69. That I needed to post my
appreciation to all who put thier knowledge into this effort
Thank All of You
cagreer@att.net

I have columns representing company, company's product, and company
street address. all this information is in a row. i have about 800 rows
in my spreadsheet. i want to filter this spreadsheet so it contains
only products that are made by 10 companies or less. that is, i want to

I have a general ledger that I am trying to create. I need to know what
function do I use to automatic post items from the general ledger to their
sub accounts

Want to sort a sheet by one column and have info in rows stay with column entry
Thanks

I searched on this NG but I can't find a solution to my simple problem.
On Column A are dates, e. i. 09/28/06 format. On column B are values. I'd
like to get the total on Column B if the dates on Column A are days in
September.

I am using excel 2003 and am typing a customer list of 3,000 names.  I found
once I type a name, when I begin to type it again, the program AUTO FILLS it
, which is great because it cuts down on my actual typing.  Therefore, I want
to know if there is some way to set up my ...

I am trying to sort data that was emailed to me.  I am only trying to
sort one column in descending order and this is what it does:
387  
399  

I work in a hospital and I have a worksheet of data from the patients we
treat. One column has their ID number and I want to add a column next to this
to which I can add a series of random numbers as a security measure when
passing data to different departments. I have read a ...