I have two sheets. The second sheet obtains data from the first sheet. The
value (£) depends on three criteria in the same row. ie Code,Cost centre and
Department.
When all three match the value (£) is returned or if not 0.

Hello -
I have a column that has a date in it and I would like to create a function
that will display the following Wednesday's date in the next column.
Is this possible?  If so, can someone please tell me how to write the

i have a table with data in that i'm trying to mailmerge, however when i try
to do that it's using the data on the left hand column as opposed to the top
row of headings.
can i flip the table around to make it work, i know you used to be able to

I have a large spredsheet of data that comes in like 6'-3 3/8" that I need to
split out so I have the 6 (feet) in one column and the fractional inches (3
3/8) converted in the next column to 3.375, etc.  Below is some sample data:
4'-1 3/8" to 4 | 1.375

For example:
For sheet 2, Cell C 5, and C7 already got data as 1015 and $30 respectively
when I'm in sheet 1, at cell G 5, if I link "Sheet 2 C 5" to this cell, it
will replicate "1015" tho this cell.... but at the same time I would like to

I have a spreadsheet in which I have a series of named ranges that each refer
to a series of cells on a given row of the spreadsheet.  For instance
row101=Development!$C$2:$M$2,row102=Development!$C$3:$M$3, etc.
I am interested in using these "Names" in "Match" and "Lookup" ...

How do I get a message to pop up when the user moves the mouse over the cell?

I have a Marco that runs a series of VLookups from a button in the excel
sheet. The Macro is stored in the personal worksheet which is always hidden.
The workbook is used as a template that is stored on the server where it is
access by multiple users. My problem is that some how ...

    What formula can I use to add 3 working days (9-5 mon-fri) onto a date
cell (E38)?

I have an array-entered IF formula in Sheet 1 that looks up data in a range
of rows in sheet2 column a, and returns matching data from Sheet 2 column b
to Sheet 1.
I'd like to be able to insert rows in the middle of my range in Sheet 2 and

I am trying to create a macro to find duplicated companies in a list. I have
a function which will tell me if a company is duplicated, but my problem is
that it is defined on (e.g. A2:A300). I want to define the formula on the
print area so that the macro can be used on any list ...

Is there a way to use an IF formula to pull information from cells based on
whether the formatting of the cell matches the criteria formatting.
ie...in words, I'd like to do this.
If F1 is shaded with the dot pattern, pull A1:E1 to a summary sheet.

I have entered data into a column. there is over 1,000 entries but I have
mistakenly entered repeat data without knowing and I now need to filter out
the replicate data without sifting through it manually- is there a way??

Difficult one for wizards!
I am trying to compile a payroll for ships crew whose pay is calculated on a
30 day basis irrespective of calendar days in month. So for instance for the
month of february 08, assuming a salary of 1,000, and the crew member signed

I need some help creating a function or formula in Excel for the following:
•       Example: payment amount is $2,589.32
        Run a tape: 2+5+8+9+3+2 + 6 (how many numbers you have in $ amt) =
35 --- 35 is your verification code.