I have an interesting problem-one that is confusing me and my collegues.
I have a workbook with 2 sheets.
One Sheet 1 I have a row of data, first column is data, next column is
more data pertaining to the first column.

So my title might be the best way to answser my questionb ut I'll give
it a longer description here.
I don't want to clutter worksheetA with hidden fields containing
formulas that I would then call in WorksheetB.

I have two worksheets.
Worksheet#1 has a unique ID field named ID which is populated, and some
other fields, including a field named Formtype that is populated, a field
named Hours that is blank.

Hi there, first time user here.
I am looking for some help with a personal worksheet I am creating to
control stock of medication by usage. What I need help on is that I
have an initial value in a cell (stock level) and I need to add to it

I am looking for a formula in excel that will compare to columns of data and
put a result in another column.  Basically: "If the number in column A (each
row will have a different number) appears in column E (any row and may even
have multiple occurences), put a Y in column G on ...

Hi Group,
I have 2 sheets. One called WORKSHEET one called REPORT.
In the report sheet I want to copy a formula down the page so
that the referenced cells increment by 12 instead of 1 as per

The TRIMMEAN function gives you the average of the interior of a
distribution, where you cut x% from both the top and the bottom.
Is it possible to easily modify the percentages, so I could  find the
average between specific percentiles? Say, finding the average of the

I would like to set up a period report which displays a set of milestones
and measures each of them against a baseline reference giving a couloured
indication: green if on track; amber say 10% out; and red, more than 10% out.
can you help

I have a workbook with two worksheets. Worksheet1 has most of the dat
I need except for a couple of columns. In worksheet2 I have the dat
that I am missing from worksheet1 in addition to some other data tha
exists in both.

When I insert a comment into an excel spreadsheet, there is the little red
indicator in the upper corner, is there a way to print your sheet and have
these indicators show up on the printed sheet?

I am trying to find a formula that will sum the numbers in a group of
cells that have a specific letter in the number: The letter will be
either "A" for one formula or "S" in the other.....
The numbers/letters in a cell look like 5S or 2A - It is for Annual or

I am trying to put a check into a worksheet that look down a list of
concatenated items and if a duplicate appears it tells me, if not it
says ok.  As entries are made into the datasheet it needs to be checked
against the rest of the items in the list to see if it has a duplicate.

Im working on a data base with several thousand rows and about 60 columns on
the second worksheet named 2006.  The first worksheet contains fomuals based
of the number on the second sheet.
The first column of the second sheet contains mutliple codes.  Some of the

We have a file with two worksheets
the first sheet contains data in the following order
A              B               C               D
date      order-id    document   quantity

I have one question. I think it will be simple for You.
For exaple I have array:
Length            Width                    Thickness              Mass
40                    40                        2,0                        1