Hello everyone,    Using Excel XP.
In this example I want to total B1:B4 ONLY if the date in A1:A4 has arrived.
In C1 I have a formula of sum of B1:B4, which I want to equal (B1,B2,B3)
because the dates in A1:A3 are greater than today (Oct 25, 2006).

Re:  http://www.contextures.com/xlPivot05.html#TopItems
I use the data file from the above site.
I drag "name" to the row fields area and "score" to the data items area.  Then I double-click on name and select top 5 scores.  I can even sort in ascending order of scores.  No problem ...

I have never understood why the $ button on the formatting toolbar has
a tooltip that says Currency Style and yet it applies the Accounting
style. It has been this way for years.  Am I missing something or is
that a boo boo in Excel.    Thanks for the input!!

In excel, trying to make a menu list for invoices.  Able to drag them to
lines and have them stay there for another application.

here is the thing, when you open a new excel file,if you notice the scroll
bar on the right it is of a bigger size, but as you keep entering rows of
data, it starts adjusting the size automatically, understandable. but now
here is the problem...when you even delete the data it ...

I'm modeling a two-step industrial process for work
Step #1 occurs anytime (date or day of week), step #1 requires 21 days
to completion
Step #2 follows step #1, but occurs ONLY on Mondays, so, for

How can I compare two dissimilar sets of numbers in two columns (random order
) and check if any of those numbers in the two columns are similar?

The results of WEEKNUM() don't correspond with the calendaring system I
want.  
My first question is simple: How does the WEEKNUM() algorithm work?  If I
can figure out what it's based on, I can probably match it to the calendar

how can i distribute the letter in a cell to another cells?
example:
A1=HELP
then get each character

I'm working on a report card for my mom's school, and I need to set up a
Macro Button that will Copy the test of that sheet's label & paste it into a
specific cell.  This is what I recorded, but I'm getting an error at "Active
Sheet.Paste":

in excel, select to insert hyperlink, an dialoge showed, then choose
file, a form- "link to fille" showed,
does anyone know how to show this form in VBA

does anybody know the difference(s) between the two different options
in excel 2000:
File -> Save As -> Tools -> General Options -> "always create backup"
and the

how can i distribute the letter in a cell to another cells?
example:
A1=HELP
then get each character

we have made an excel-sheet which is connected to an access-database
with the add-on template-guide
(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=E01EA3D8
-094D-4ED1-88DA-F4B8B2AD28BD).
It is working fine but we would like there to be a button which is

 I'm sure I'm being dumb but I can't think of a way to solve this. Any
help appreciated.
Given three given values of  "Start", "End" and "Length", I need a
function for variables time "T" and values  "X" where at T = 1 X=Start