Is there an easy way to extract the highest x (say, 6) consecutive
values from an array (say a1:a20)?
Thanks
Jim

Does anyone have a template that creates a nice looking excel chart
using  data (Task, Start Date, End Date) maintained in an excel
spreadsheet? I'm trying to mimic a ghant chart in MS Project, which is
not available here. Would like to copy paste into Power Point as well

How do I get an ambersand (&) to show in my headers & footers in excel?

I am using arrow keys on the keyboard to see and edit through the excel
sheets. When i click the arrow keys on the keyboard, instead of the focus
getting changed to another cell, the sheet is getting scrolled as if the
scroll bar arrow has been clicked by mouse.

This is the first time that I'm using the Mileage Log, How do I get the total>

I have an excel spreadsheet I created for when we get a new customer.  The
user opens the protected sheet and enters info by tabbing from cell to cell.
I have changed the format of the email address cell to be Arial Narrow and
bold, when I enter info and tab or enter out of that ...

I imported  this data into a spread sheet-  I tried to format it to number,
but when I sort it- I get :
     37.08
     4.33

Is there a way for me to have the data in a cell determine how many
decimal places should be displayed?  For example, if the formula in
the cell results in a number that is greater than (or equal to) 10,
then I'd like to have zero (0) decimal places actually displayed.

I have a multi page printout of a worksheet where I do not want the header to
print on the first page. I know that in WORD there is a way to specify
non-printing of headers and footers on the first page since it may be a title
page or cover sheet. Is it possible to do the same in ...

I imported some numbers into a column find that I can not do any mathmatical
functions with those numbers.  I noticed that their was a Space at the end
of each number and if I deleted that space, then I could work mathmatically
with that number in the cell.

I posted my question in the programming board here:
http://groups.google.ca/group/microsoft.public.excel.programming/browse_thread/t
hread/11bada939dbf45c0/69530d8a32d69d85?lnk=st&q=kaken6&rnum=3&hl=en#69530d8a32d
69d85
but I’m not sure if it was the correct location nor gotten any

Have an Excel Spreadsheet that I am unable to add or delete any worksheets
from.  I can't for the life of my work out why.
Can anyone help?
Cheers,

I have a worksheet with Colonm Headings and Data below each heading, except
the "Column A" (in some cases it has and in some cases it doesnt). I want to
extract all rows where there is data in "Column A" to a separate worksheet.
The Entire Row should be copied to the new ...

Help Pls.
i want to enter data in the first tab, without retyping them in individual
tabs have the automatic sepeared in other tabs.
exp.

I have quite a complex VB Excel file with many macros and Forms.
All works great on my PC, but when the file is opened from another users PC it immediately comes up
with a Copile error.
The VB line highlighed is :