just advising that i have put my template up on MS for thsoe who will
need a tool that tracks purchasing based on account codes & shows
calenderisation of those purchases
be advised that this tool was designed for my use but put general

I GET UP A FOOTBALL POOL CHART USING EXCEL. BUT I DON'T WANT THE ALPHABETS
SHOWING AT THE TOP OF THE WORKSHEET AND I DON'T WANT THE NUMBERS SHOWING
EITHER. I WANT TO REMOVE THEM BOTH FROM THE WORKSHEET

I'm experiencing troubles when doing a sql against a .dbf file with a name
longer than 8 digits. But just in some computers, others work fine.
What makes this and how to fix it?
Thanks,

I need to assign 1 to Y and 0 to N, so I can run a average on that
column

Paste any of the following into a cell and the last digit gets changed to a
zero. This is screwing up our call detail records that contain international
numbers dialed by customers.
9011390292608271

I want to find something that clears a whole column (or a range in
that column), when a formula is true.
The problem that I see is that if this column is in a range that (for
instance) sums a row whithin the range of the column, the

I want to count the number of times two seperate things occure in
diffrent rows.
I want to count the times "v" appears in rows C7:AG7 AND the times
someting is put in rows e7:eG7.

hey guys,
just curious if this can be achieved or how it can be achieved
say i have this
Column A Row 1 = Short Description

Can I do a mail merge from one excel document to another?  I want to have a
name at the top of each page that is different from the previous/next page.  
I have the names as a list on another spreadsheet.

I need to make packing slips from an excel distribution list.
I would like to repeat the header rows on every sheet then copy or print 1
row at a time. Each row equals 1 packing slip's worth of information.
I need to either just print 2 each with this configuration or make a

In Excel 2003, when I double-clicked on an Excel file from an Explorer
window, Excel 2003 would launch and open the Excel file.
I have upgraded to Office 2007.
Now, when I browse to a directory and double-click on an Excel file:

What I want to do is: when I select a cell I want a list of choices to come
up to choose from. I then pick the item and it is entered into the cell. I
saw in one of excel websites and I cannot figure out how to do it. Would
appreciate any help.

I need to make a sheet that contains a list of my team members and the
days they want to take a day off.
My team consists of nine people and there should always be 6 people
present.

This formula represents dates   dd  mm  yyyy  over 3 seperate cells and
deducted from a similar formula to work out how many weeks at £s per week.
=IF(DATE(K7,J7,I7)-DATE(G7,F7,E7)>=6,229,0
It is used as part of a spreadsheet to work out a monetry deposit for

good afternoon All,
I would like to know the SQL to select only the "top" record of a query
sorted by date/number or operation of numbers e.g. max of date, min of
stock, etc so I only retrieve the first and most important value instead of