Hello, I have an Excel 2002 question. Is it possible to use a data validation for one cell which checks for input (in my case the word "Other") in one...

Could someone help me? What I need is to compare one cell with 35 other static cells. If the data in the main cell is the same as any of the other cells it...

Hi try =WORKDAY(A1,4) where A1 stores your start date you may also add a third parameter to WORKDAY referencing a list of holidays (see Excel help for more...

Hi Basil, The following is a nice comprehensive answer compiled by Norman Harker. You should try a Google search for questions as you might imagine that...

I work at a school and need some help in creating a formula and/or program for the following problem: Our school drops students from enrollment if they have...

Hi You wer close! Use the Formula Is option try this: =AND(F3$F$2,F30) Hope this helps. -- Andy.

I have created a Custom Format to Zero Fill a Numeric Cell but can not get the cells to display the Custom Format with out Editing (F2) each field and pressing...

Hello All, I am creating a worksheet as follows: Col Headings A1 = Team (can be either Y or Z) B1 = Criteria (can be either A or...

"Julie" skrev i melding ... I use Windows 2000 and Excel 2000 at...

I am currently producing a data sheet which used values selected from 2 combo boxes to produce a given output. The problem is that I would like to have the...

I'm trying to set up a time sheet at work using excel. I have set up my sheet to calculate each day of the week individually. (M, T, W, Th, F, Sa, Su). I...

I can't get a simple routine which should bring up a message box every time the worksheet is calculated: Private Sub Worksheet_Calculate() MsgBox "OK" End...

We run on a novell network. Most of our office databases/documents have a field for Name, or Initials. We want to link the excel forms to the user name and/or...

When opening a .csv file or pasting in a column of number with the format of "01-5308", Excel autoformats to "Jan-08"...then when converting the format of the...

I have a spreadsheet with the date as column A and hours in column B. The date is in mm/dd/yyyy format. I am trying to sumarize the hours in column B for a...

Is there a formula to count styles in a worksheet? I've assigned cells individual styles based on formatting options, and need to tally them. Thanks!

How can I search and remove duplicate records from an excel work sheet?

I am creating a telephone directory in Excel that has name, followed by dots (leaders) reaching the phone number. Some contain other info also. I am importing...

(This is an updated posting) I have an analysis spreadsheet that is essentially a database of test results for various products monitored. Presently I have...

A co-worker of mine has a question pertaining to Microsoft Excel 97. She is wondering if, if the same text appears in both an Excel spreadsheet and in a chart...