I need to set a column to upper case. I am sending out spreadsheets to various departments and when they enter in certain information into a series of cells...

Here is the data I have Order# Order Start Time Why Didn't Order Start 345 11:00 AM Parts not...

Howdy all, I have a list of data in cells b3:b103, and I would like to input a maximum value criteria in cell a1. Then I would like any value in cells b3:b103...

I have an Excel 2002 workbook which has many worksheets. One of these worksheets is a TOTAL of the other worksheets. One cell in the TOTAL worksheet is using...

I posted my previous question at 12:20pm. I got some help but I don't think I'm being clear enough unless I'm just not following the answers I received. I...

In cell a1 on sheet one I have a date in this format sept-28,04. but on sheet2 in cell b1 I entered =sheet1!(A1) or however the formula goes I'm sure you know...

Essentially I want to write a function that says this within cell b1: if cell a1 starts with the number 1 then goto c1, or if a1 starts with the number 2...

Is it possible to tdo following: Working with Data Validation, On sheet 1 I have six lists named one, two, three, four, five, and Other. they are located in...

Hello, Here is my request, sheet 1 sheet 2 ------------------------------------------------------------------------------------------------ In Sheet2 cell b2 ...

I am have created a workbook that uses an add-in function (the YEARFRAC function). This workbook will be distributed to other users that may not have the...

is it possible to create a drop down menu in excel?

I used a vlookup function and now some cells return #N/A. I understand why this is happening but it seems far to difficult to go into detail about the vlookup...

Can anyone tell me what the following file name means: I have an excel program that I named Patrol Log. I saved it originally on my HD. But then I copied it...

I am trying to create a macro and am stuck trying to figure out how to determine my last column. In cell E3 I am using the formula =COUNTIF(E4:??,0). Can I...

Excel 97 Won't Print Landscape on HP4000

The Indirect function does not seem to work for a range of worksheets. For example, Sum(Jan!:Aug!A4) works for summing all the A4's on the worksheets between...

I password protected a large, multi-tab workbook so that shared users would not alter the structure. Even though I have a long history of well-documented...

February 2, 2004 I use Excel 2002 . I need a macro to create a text box with the properties not to resize with cells, and print with page. I've had a...

Thank you very much for anserwing my bold function question but I get a #value error when I try it. Sometime it takes me to the VB part and highlightes the...

In Cell D1 if I am looking up the contents of a cell C1 (in this case the name "bill") in the range A1:B10 and "Bill" is found in B2. Why is it that if I ask...