I have two columns. In Columns A I have dates and in column B I have values.
It might something like this:
     12-02-2008 34
     13-02-2008 37

I am trying to figure out how to create three simple columns for a cue
sheet of map directions.  One with distances to each turn, the second
with cumulative distances to each city - reseting at zero with each
new city and the final a simple running total of the odometer.

I’ve run into a problem when trying to sort information. Here is my problem.
I get many blue prints each day that have numbered with areas that need to be
measured. Each blue print is different. On one blue print I may only have
three (3) areas that need to be measured when a ...

In column D I have a date in the standard format of 22/02/2008, in
column K i would like that date to be displayed as the month and
year.  So in this case "Feb 2008"
I believe i can just add a simple formula that will lookup the date in

I'm exporting an ASP page to Excel using 'Response.ContentType =
"application/vnd.ms-excel"' and it is working fine for the most part
except the particular page I'm exporting has images, and no matter
what style/alignment/etc. that I provide to the <td> tag that contains

if I have a database created in Excel with Names, address, ect. can you
create lables for mail outs like in Word?

A Heritage Society secretary gave me her mailing list for the recent
newsletter. It is an Excel document, and it was a disaster. A couple
dozen listings didn't print. I found about a half dozen that had
serious mistakes. She later identified them as entries that she had

I often have to view two pages of the same workbook at the same time.
I can open a new window and set them up side by side within the same
spreadsheet window.
Is there a way I can lock them such that when I scroll in one it scrolls the

Hi, im in a fix as an employee has placed a password on open on one of my
documents, she does not remember what the password is, can you help me to
figure out how to recover this password. I have tried numerous recovery tools
and still no luck.

I have a range of cells spanning multiple columns and rows.  I would
like, in my fantasy, to just hightlight all of them and say "multiply
by x" where x is an integer.  Now, I know I can't do that because my
microphone doesn't work, so, other then a macro, is there a way to do

If I have 4 values that reside in a worksheet in cells F1:F4,
how do I take these values  and specify these as criteria in my where
clause:
WHERE ID IN (F1:F4)

I have data of travel time between 2 locations each day. There are
columns such as date, start time and end time in multiple columns.
How can I find the average of travel time on Monday, Tuesday, Wed etc
and the average of travel time if start time is between 7:00 to 7:30,

Hi - hope someone can help.
I've been asked to set up a master table showing student allocations to
different departments on different dates (e.g. Mon-Fri, Jan1st-Dec31st),
where 1st table acts as master table, copying data to other tables in

We are having great difficutly making cell selections when a worksheet
includes merged cells that extend outside the desired selection.  For
example, we often divide a table into major sections vertically by merging
all the cells in a given row and then entering a major section ...

Hi, I have a spreadsheet that one of our disgruntled employs upon resigning
he has password protected the sheet. He has placed a password in the on open
option.
I have tried various password recoveries and still no luck, can someone