I have a range (SOURCE) that consists of non-contiguous cells in a column
(eg. ='Log Sheet'!$O$61:$O$110,'Log Sheet'!$O$125:$O$174,'Log
Sheet'!$O$189:$O$238,'Log Sheet'!$O$253:$O$302,'Log Sheet'!$O$317:$O$366,'Log
Sheet'!$O$381:$O$430). When I use the range in a formula

In a macro I have the following line:
ActiveChart.Location Where:=xlLocationAsNewSheet
How can I use a different line to put the chart in a sheet e.g. Sheet_Chart
that is already present, in a particluar place?

I know that I can use the MODE function to get the most occuring value
in a range; but is there a way to list the next 9 most occuring values
in that range?
Thanks in advance

Hi
I was wondering if anyone could help me with a minimum payment calculation
on my spreadsheet for my Credit card
I have the following Cells

I have an Excel work sheet that has a Drop down box with Active and
Non-Active and I want it to have Yes and No.  It is not a form because there
is no coding attached and it is not a filter.  Please Help

I have a column that has entries that start with Fiscal year 07 numbers which
are from 07/01/07 to 06/30/08, and a cell that gives me the average so far
this year.  Is there a way to take this col Fiscal year and get a median for
FY07-08?

I am trying to find the minimum date in a range, which contains blanks.
subject to a criteria.  As the range contains blanks, these are currently
picked up as the min date and display 00-Jan-00.  
Is there a way of using sumproduct and excluding/ignoring blank cells?

Thanks to all your help, I now have a functioning toolbar that makes life a
lot easier for my users.
But...
now that I have it, how do I get rid of it?

I have this macro:
Sub GetTerminations()
Const SumSheet = "TERMINATED EMPLOYEES"
Const BilingualSheet = "Employee Bi-Lingual Skills"

HI
I have a list of series like this
serie 165125
serie 165126

Hello,
I have a spread sheet which tracks whether an item has been paid or not. It
also looks at the amount claimed and compares this to the amount paid and
returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the

I have Excel 2007 - I have created a drop down list in column "I" the drop
down boxes are in column C  -  Although my list (col I) is sorted A - Z my
drop down box opens with the list showing Z - A.   I want it to open with A -
Z.   What am I missing?  I have searched "help" with ...

How do I sort the results of a Pivot Table in descendant order?
JPG

I am trying to do something like =IF(A1>10,RunMacro).  I realize that
this cannot be done but there is a generic syntax that will basically
do this:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

I am doing a ranking (1,2,3,4) where 1 = 6 points, 2= 4.5 points, 3 = 3
points and a 4 = 1.5 points.  Any suggestions on how I can capture the 4.5
and 1.5, I was using the Match function, where =MATCH(G12,{4,"b",3,2,"e",1},0)