I've got a column with a list of times and want to
calculate the number of instances in the list that fall
within 12 hours.
ie. In the table below C6 should show the number of cells

I have a function that creates unique tabs based on a column.  
programmatically set the Center Header to a string listed below.  
also need it to display the tab or worksheet name, but whenever I ad
[tab] to the string below it bombs out.  How can I get this to displa

i got around 300 excel files and the data is entered as
Column A has the headings and Column B has the data
and now i want to maintain it as a database.Presently i am having approx 300
files.

If I have a minus value in excel then normally it appears with a '-
before the number... fine.
However, many accountants want to remover the '-' and replace wit
brackets '(x)' around the number.  This makes it easier to spot th

The conditional statement I'm working with is:
=IF(AND(A3=A2,B3=B2), 'Au'!E1,'Au'!E2)
Here's the problem, I want to fill the column with this
conditional statement but if I do that it will

Hopefully your about Bernie as you well know the macro below. I'd
tested it a number of times on my Win2000 machine and it works
perfectly.
However, I have some how put a spanner in the works. Now that I have

I would like to have a formula that has several if
statements in it and give me a dollar amount for the date
and code that i specify.  for example i have a spread
sheet set up as follows

The spreadsheet is being misformated due to autofill and border copying
Is it possible to do away with this function and force users t
manually type each number?
Thanks

I have a simple question. I have a cell that has date that looks lik
this:
10/15/1999 14:34
When I use the concantenate feature my date looks like this:

I do apologise about the rather odd sounding subject and post
What I am hoping to do is....
Range("a1") contains the variable  28  (ref from a dropdown box)
(in a particular cell)

Can someone tell me what function works to count the number of cells
in a given row that contain text?
Many thanks.
Tim

I have Multipage on userform.
Each page is with different informations selected by controls on thos
pages.
I need only to print the pages indivully (say clicking a button on tha

On my office PC, I have Office 2000 with WinXP installed.  Most of the other
users have office 97 on NT 4.0. They send me spreadsheets all day, as I do
the night balancing for the department, so I must print out all the
spreadsheets.

I am a relatively basic and new Excel user...I'm not very schooled in Macro-building or running or what have you!
I've been given the task of randomizing a list of words.  They are currently in one long column in Excel...
Is there any way to do this without a Macro?  And if not.. ...

I'm curious if anyone has had success trying to design an area chart
as described below:
1) The graph depicts annual benchmarks / net returns (Y-AXIS) versus
year (X-AXIS).