I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet.  I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number.  Is there ...

I am working with 30+ workbooks which contain timesheets (tabs) for every day
a job is worked in our plant.  I have inserted rows at the bottom of the
timesheets which will gather the information from the timesheet above so that
this information can then be moved to the first ...

I've been using the following formula with teh cntrl+shift+enter, but
I'm not really sure what it does.
=INDEX(E:F,SMALL(IF(E:E=E2,ROW(E:E)),ROW(1:1)),2)
What I'm trying to get the formula to do, is I have list of 135 user

I am having problems with a calculated field in my pivot table.  I have each
persons daily time available in a column, the table averages that data for
each person, the only problem is the time is in seconds and I want to convert
it to hours.  It is too cumbersome to manually ...

Once every couple of weeks or so (I use excel a lot), for no apparent
reason, all the cell background colours (except white) will shift
slightly. When I open the color palettes, they have changed too.
Closing and reopening Excel tends to help (but not always). I have no

Currently importing banking data that includes sort codes but EXcel 2003 is
automatically converting the 01-07-07 format into date format 01/07/07.  When
I format to Custom or Text it appears as 39264.  Any suggestions on a formula
I can run to convert them all to the correct ...

hi community
how can i place leading zero infront of number, i am using excel 2007
n
if yes!...where can i do the setting ?

If I have a Word 2003 file, is it possible to attach an Excel 2003 file to
the Word document (including page tabs and links)?

Afternoon from a sunny RSA,
Four sheets, three are input sheets and the last one is a summary sheet.
Sheets 1 to 3 are vehicle specific. Truck 1, Truck 2 and Truck 3.
One each sheet is three columns, Date, Driver and Kilometers travelled, so

Using Excel 2003: I have a worksheet that I have to update daily from data
that is created by an SQL query for orders created and not sent. I have to
distinguish between production and test vendors. I keep a separate worksheet
that has the vendor number & description and status. ...

For my job i have to track my own hours. I am trying to make a sheet that
will add up my own hours for me. I have four columns that I type in my hours
and then I total it for the day using "=TEXT(G6-F6, "H:MM")". But then when I
try to total it for the week it comes up with a ...

I've been using the following formula with teh cntrl+shift+enter, but
I'm not really sure what it does.
=INDEX(E:F,SMALL(IF(E:E=E2,ROW(E:E)),ROW(1:1)),2)
What I'm trying to get the formula to do, is I have list of 135 user

hi community
can anybody please explain to me...
what is the real usage of the "Justify" in the Fill icon under the Edit
Group at the Home tab (excel 2007)

not seeing what missing, trying to make the following:
=AND(NOW()>"16:00",$DR$3<"16:00")
where Now()>"16:00"  seems to return the opposite of the actual time.
if 17:00 is the time, I get a FALSE.  is there an error in my example?  

I have amounts in a row formatted as USd and AED.Cell A1 200 AED and cell A2
$200.I need to differentiate these two and I should able to capture the USD
alone.The idea is to seperate all the USD.Filter is not working.Please advice.