How can I filter data to show the top 10 AND the bottom 10 items at the same
time? The Autofilter gives the option of one or the other but not both. My
data is set out as shown below. I've used a macro to filter using advanced
criteria for 'Sector' but I would like to be able to ...

I have formatted a cell for dates. When I enter a date it will put a = sign
in font of the date and will not display the correct date. it displays 1/0/00
as the date. How do I get raid of the = sign.

How do I get Excel to display 0.00 instead of a -.

I'm trying to make a report card of sorts with Excel 2003. On one sheet
will be where I type everything up -- classes, grades, scores, etc. In
one column (in my case, B, starting with Row 4), I will type in a
letter grade (A+, A, A-, replace A with B~D and F) and the column next

I need to multiploy a large spreadsheet with many values by 1000 with out
going into each cell.  I would need to turn ea. cell from a value to a
formula.

I have created a drop down menu. Each customer  has 3 or 4 presses, on
my worksheet if I choose a specific customer I should have the
specific pressess , but the list contains 0 values as well as the
presses that the customer uses , how can I get rid of the 0 values

I have a yearly roster with 4 staff 1st sheet="roster". Am trying to sum
hours for each week for staff on their own sheet, eg 2nd sheet="kerry". Am
assigning each week with name eg week1 to week52 range so next year only have
to change name range and leave individual staff sheet ...

I'm having problems with the formatting of a web query inside of a macro.  
Maybe this is best posted in the programming group, so I apologize if that is
the case.
When I go to a web page -- http://finance.yahoo.com/q/is?s=HD&annual -- and

I am a newbie at excel so I would like to know How to do the following.
Cell A1 would contain 1 date A
Cell A2 would contain a second date B
Cell A3 would contain a number X

xl2007 formula "COUNTIFS" as following:-
=COUNTIFS('MTD Reach'!K:K,">0",'MTD Reach'!A:A,B12:B277)
*Criteria range 1 = 'MTD Reach' (Sales data)
*Criteria 1 = >0 (More than 0)

I would like a formula that can return a numeric sequential count down a
single column based on content of another column. The count will be
sequential until it meets all the criteria, wherein a zero (0) should be
returned and the count reset, starting at one (1), until the criteria ...

I need a formula or vba code to bring back the numbers between a range of
numbers.  For example, in sheet1:
Col A    Col B
05         10      

Col A has a slew of part numbers with many of them repeated; Col B has
a transaction date for that item.
On sheet 2, there's the list of items which appear in colum A on sheet
1 (none repeated on sheet 2).  I'd like to populate ColumnB on sheet 2

Is there a function opposite to concatenate that splits text in a cell?
Thanks

Running Excel (Office 2007) on WinXP.
My spreadsheet is used for tracking sales of Girl Scout cookies.  Need to
determine how many cases and/or boxes of cookies are needed.  12 boxes per
case.