In Column A I have the ages of a random number of people.  I need to
take the median of the top 25% of this list.  First I sorted the list,
and now i need to run Median(A1:AX) Where X is the cell that equals 25%
of my total population.  My problem is the population(and thus the

I would like to include the offset function into chart references but Excel
is not letting me.  For instance, under the series tab in the chart process,
I would like to change these X values =Sheet1!$A$1:$A$25 to
=sheet1!offset($A$1,0,0,35,1)

Hopefully this is a nice easy one that somebody can help me out with :-)
I have a column of data with formula's in (forecasted sales) during the
month I over key these when the actual orders come in. Is there a way that I
can set something up so that when I over key the formula ...

Greetings All,
I am new to this forum, so excuse me if I stumble.  I must find a way
to accomplish the following:  Search below a cell for the next matching
cell, and post all of the "unique" values included in the search,

I have A1:A4 cells filled with -1,2,3,4 and named the range A1:A4 "sales"
in A6 I have =SUM(IF(sales>0,sales)) outcome 8 (=-1+2+3+4) and it should be
2+3+4=9
When I click the Fx button to edit the formula, the outcome is correctly

Add Visual Foxpro 9 DBF format import / Export to Excel 2007
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

I need to count the head to head results in a poker league. There are 7
players and the league works with points being allocated for all
places. I am interested in only the winner and second place. I want to
count all the final (tournament poker format games work on a knockout

I've looked and can't see if theres a way that you could automate a search so
that it would change a cell  reference.
I have a large sheet of thousand of customer ref. no. what I want to do is
create a reference cell or tool that I can type the ref. number into and it

In Excel I have been trying to find an easier way to calculate a time
difference where the times cross midnight.  Example:
Start time:  23:50:00
End time:  00:15:00

If A1 is greater than A2, the Replacement Cost or Total Cost to    
Re-Build is the minimum amount required.  Enter Required amount in A5.
If A2 is greater than A1, compare A3 to A1.  If A3 is
greater than A1, the amount in A3 is the minimum amount required.

Can I modify this:
=IF(MID(N3;6;3)="OLA";MID(N3;6;3)&LEFT(N3;3);Y3&MID(N3;6;1))
to include this:
If AP3="PA-OUT" then ("PA" & LEFT(n3;3))

In Column A I have the ages of a random number of people.  I need to
take the median of the top 25% of this list.  First I sorted the list,
and now i need to run Median(A1:AX) Where X is the cell that equals 25%
of my total population.  My problem is the population(and thus the

Please don't laugh, but I am having difficulties coming up with a formula
that satisfies all criteria.  This is the situation for a single cell, Line 5.
If Line 1 is greater than Line 2, then Line 2 is the minimum amount
required.  Enter that  amount on Line 5.           

How can I set up a cell's pattern color to automatically change to red when
a certain date arrives? I would hope it could be done without VB as my
knowledge is very limited.
Thanks for your help.

I have two linked worksheets and I am trying to update the drop down menu by
adding an entry.  How do I do this.  I am totally new at this and flying by
the seat of my pants without a manual (which we all know may look like it's
written in an understandable language but isn't ...