Within a post logging spreadsheet, the date of logging is automatically
entered against each entry on the day the data is input and formatted thus:
'21-Jun' . I wish to find out the daily min, daily max and daily average of
the entries over the year and, if poss to adapt the ...

=COUNTIF('BNSF 2176:BNSF 8037'!I1,"GP38")
I am attempting to count the number of times the text string "GP38" is
present in cell "I1" of a select group of worksheets within the same work
book.  The error I get is "#value"  When I run error checking on the funtion,

~  I have created a time chart which uses conditional formatting to produce
time-bars which look a bit like MS Project time bars.  Year weeks 1 - 52
start/finish dates are on the top, horzontal axis, event dates are on the
left, vertical axis.

I want to merge two sheets and use the merged data in a new sheet.
Both my sheets contains similar info but there are fields that differ.
I need Column A from one sheet to look in Column D of the other one to see
if that one contains the same info. A simple return like False or ...

This Macro is almost working, but there is a slight glitsch......When the
person's data from Worksheet 2 to Worksheet 1 start paste in Range A4, only
the first line of data pastes to A4...the rest of the person's data pastes
down below in lines 42 down.....Any help would be ...

Hi Helpppp!
Sheet 1 is something like this
Colum A6 to A51 is a customer name
Column B6 to B51 is a industry region

I have a thirty day worksheet with numbers entered each day form .1 to .99.
Is there any way to calulate how many times .25 was entered two days in a row.
example .25  .25 .10 .87 .25 .98 .25  .25 , in this case it would be two
times.

Hi Helpppp!
Sheet 1 is something like this
Colum A6 to A51 is a customer name
Column B6 to B51 is a industry region

After 20 years of manually assigning payment formulas to dates in my
cash forecasting models (it only has to be done once a year), I am
tantalisingly close to doing it by function.  In my test case, the 12
monthly paydates are in DC25:DC36 and the amounts are in DD25:DD36.

I’m working in Excel 2003.  I’m working on a project that will track
employee’s errors (dollar, procedure, or no errors).  I have 13 worksheets.  
The first one is titled Summary and is followed by worksheets titled January
through December.  The Summary worksheet functions as the ...

When I open a workbook it prompts me for:-
"Update" or "dont update"
"Workbook linked to other sources" type of message.
The workbook concerned is a copy of my original in another folder (I always

I have a worksheet with a summary page like
Column A Customer name
Column B Industry and in colum H I want to return a budget figure based on
the two criteria of Column A & B.  The budget figure is in another sheet

In a worksheet with a orderlist,I would like to print only the part of the
list that I shall order,and not the whole list.How do program the
worksheet/book so that this is possible?

I don't know how to explain let alone set this up.  I have some information
from a database that relates to a separate database.  I need to cojoin the
information in excel.  The problem is the first information needs to have the
common field changed.  It was entered as 0545 and ...

I have a spread sheet used for production planning which predicts the finsh time of a job depending on its duration. This works fine but I now have the problem that production is no longer 24 hours so if a 12 hour job starts at 15:00, no work will be done between 21:00 and 06:00 ...