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...

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...

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 You wer close! Use the Formula Is option try this: =AND(F3$F$2,F30) Hope this helps. -- Andy.

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...

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...

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!

(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...

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...

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...

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...

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...

Tom you have been a lot of help. I have been checking out the functions command - Index and Match vs. VLookup. I am beginning to understand you answer....

I just did a search through the newsgroup but didn't find anything specific to this. I'm trying to look for duplicates so that it would recognize ROWS A and C...

Hi all, I am attempting to write (and I aim to be successful at it) a custom Excel function using VBA. The function will encapsulate the calculations and...

Eliminating duplicate records in consecutive rows of a column I have an Excel spread sheet that has 6,000 rows of text in one of the columns. I want to be...

In the C column I have categories and in the J column I have Hours Is there a formula to where I can look up the category "Library" in C and add only those...

One possible way, not thoroughly tested though except for you...

I am trying to insert a refernce to a dymnamic cell into a text field. In other words, my text field says "number of days: AF5", where AF5 refers to the cell...