When I add multiple subtotals to a worksheet, it also adds multiple grand
total lines at the bottom.  Is there a box I need to uncheck somewhere?
Thanks...

I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.

I want to count the number of Mondays etc. in a date range.  I found the
following on Chip Pearson's site...
=SUM(IF(WEEKDAY(A2-1+ROW(INDIRECT("1:"&TRUNC(B2-A2)+1)))=C2,1,0))
Where A2 is the start date, B2 is the end and C2 is the weekday number

I need a way to find the cell containing ":" in a row and copy it to a new
column.
I would think it should be simple, I just can't figure it out right now.

Win XP
MS office 2002.
I have a workbook with a(MAINS) spreadsheet for bowls scores and placings,
using the following array formulae.

I need to extend a fill series using ref's from sheet 2.
Sheet 1 info needs to fill "down" the rows.. and the info it's referencing
is "across the columns"
How do I extend the fill series to run : A1

I have some times that I need a separate cell to look at that time and
tell me if it is AM or PM.  I tried using the Right(A1,2) but that did
not work even though I see the PM in the input bar. I also tried
if(A1>12:00,"PM","AM") but that did not work either.  Any help would

I have tried and tried to get this to work. I am trying to do this all in one
formula and I think it's outsmarted me... maybe it outsmarted me from the
beginning, but I always thought I was pretty good at this.
Anyway, I am tring take the following information from one worksheet ...

in one column i have names and in other column i have values. each same name
can have lot of values
so in column A all the names are written , (one name can have more than one
values). and in colum B i have all the values . I want a fuction which gives

Need help on this one. I want to enter the number "one" in any cell in a
column that will trigger entering todays date statically in the cell to the
right of that cell.

I am having problems getting Excel to sum a column in a series of
spreadsheets. The information comes from a SQL query and is imported into
Excel. The problem is in column F, rows 2-141. No matter how I format the
cells, I can't get a total. I have tried multiple suggestions ...

I like to know if there is a way to make "2/28/2008" appear as "Thursday,
February 28, 2008" in excel 2007? Thanks!

I am having an issue with converting the month number to the month
abbreviation.
Below Should Return "Feb", but it is returning "Jan"
1.)  ="Jobs Due In or Before "& TEXT(TODAY(NOW()),"mmm")

I have a very large Worksheet labeled 'Global Schedule'.  The first 2 rows
are used as a header.  In Col. J there are dates and in Col. N there are
prices.  At any given time Col. J cells may or may not have a date.  I would
like

Hi, I have a spreadsheet that isn't really laid out well, but is too big to
change, so I'm hoping you can help me!
I want to lookup a value in colum A, then use that cell address to lookup
another value.