I'm reworking an application I did a few years ago.  As I attempt to
"improve-it"
I'm not doing so good.  I am using Data Validation Dropdown ListBoxes.
My Column A usage is OK..   In Column B I've made another Data Validation

I have a worksheet with a total page of item inventory and then seperate worksheets within the workbook for each type of item shown on the total page.  The total page carries the last updated entry from the individual spreadsheet linked by this
=OFFSET($C$2,COUNTA($C$2:$C$28)-1,0) ...

How can I run a regression for more than 16 column data?

Regressions in Excel 2000 only allow for 16 columns.  I
have more data, what can I do?

Does the VLOOKUP method and the IF function have a limited number of characters within their parameters/argument that they can handle?
I've currently got a problem with these as follows:
This first line functions correctly:
=IF($D50=0,0,VLOOKUP($G76,'[SAC tonnages v2 ...

I would appreciate your help with this, I have two worksheets
1 = list of pc numbers and user name (this will be where my results
will show)
2 = list of pc numbers and operating system

Hello.  I have a spreadsheet of data with columns as
Column A:  Addres
Column B:  I.D. Numbe
Column C:  Inspection Dat

I do not have any cells protected before before i run the
formula.  After the formula is executed, when I open the
file again I get a box that says Unprotect sheet
password.  I can not figure this out as to what the

How do I find cells containg links in an
Excell 2000 workbook?

When unhiding rows, many of which include comments,they
all appear at the top of the page. How do I show them next
to the line item as they were originally intended?

I'm guessing there is a very easy solution to this but just haven'
figured it out yet.  Hopefully someone can help.
I have a 20 question True-False test.  The answers will be placed in B
to U4 as "T" or "F".  The test-takers' answers will then be placed i

Mmmm ... don't know how best to explain this problem.  Here goes ...
I have a regular spreadsheet report sent to me at work.  There may be 200
rows of data subtotalled into 10 sets of data.  Each line has a total which
has may be hidden but when '+' is selected all of perhaps 20 ...

Hi all--
I searched the knowledge base, and did a search through
this newsgroup, but couldn't find an answer that I could
work with or understand.

Can anyone tell me how to write properly this function. I
need the know how to write "=if a1 = 5 then goto c1",
this is just an example but for the life of I can't get
it work. I wrote queries in Lotus several years ago, but

Hello I am new at Excel for the most part and I want to design a spreadsheet that will help me figure out the cost of a product I make. I need it to be able to work with different options. I have seen some done, but not quite what I want. Can anyone point me in the right ...