Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how to remove gridlines from part of a worksheet only27 Mar 2008 20:21 GMT12
probably simple but I'm a novice. building a worksheet to list people, pay
rates and hours worked etc.  the header needs to have fill in areas that
change with the job so I entered them in the rows rather than in a proper
header.  what I want to do is get rid of gridlines in the ...
Best way to subtotal this data?27 Mar 2008 19:39 GMT8
Hello all,
I have a worksheet with a bunch of data that I need to extract certain
statistics from.  I need to show the total number of hours charged by each
person to each group they worked in for the last year.  So, I need to sort by
Second Saturday Of The Month27 Mar 2008 19:20 GMT7
OK, this may seem fairly simple but I'm missing something ...
Is there a formula that will calculate the Second Calendar Saturday of the
Month for me?
rotate columns27 Mar 2008 18:46 GMT2
I'm needing to keep a running total of the last 7 days of hours worked for
several employees.  I have it set each time excel opens the first time each
day the date will change to the new dates. however I need the columns with
the hours from the corresponding days to rotate with ...
V Lookup and Paste Special27 Mar 2008 18:29 GMT6
I'm doing a VLookup function in Worksheet A to find in Worksheet B. The data
in Worksheet B was paste special: values. I did subtotals on the original
data and wanted to see the subtotals without the detail this is why I pasted
special as values. .  
I forgot my password27 Mar 2008 18:29 GMT1
The password I thought I typed into my workbook does not work.  How do I get
into my workbook?
Remove useless information27 Mar 2008 18:16 GMT2
How can add all the numbers for a total, and only Keep in all in one line.
Example below, nubers totals 9, but i only need that with one name, one
address, one city, one state, and one phone #...I have a spreadsheet that
have been working on for two days.
track changes27 Mar 2008 17:36 GMT1
can i set up track changes on a destination workbook?  it is linked to 14
different spreadsheets.
Fill color wont' stay27 Mar 2008 17:21 GMT1
Ok, I set row 1 with a RED fill, but every time I save the workbook, it
reverts back to "No Fill". The text, however, stays white.
Any idea's why this is?
Annual leave monthly calculation27 Mar 2008 16:45 GMT2
I have made an exel sheet to calculate the vacation leave for all the
employees
and i have used this formula
C7=starting date
Double Vertical Index & Match27 Mar 2008 16:28 GMT7
Sheet1
       A           B        C
1     Date      Time    Score
2     3/1/08    0000      91
stock inventory27 Mar 2008 16:11 GMT1
I'm trying to create an inventory worksheet(maybe very simple to some of you)
where it has only two columns A(part #) and B(number of part available in
stock). Please help if there is anyway I can just enter part number in
columnA then columnB will automatically adds up quanity ...
MAX Value27 Mar 2008 16:07 GMT7
Trying to create a MTBF database...  The File will contain in Column
"A" Internal part number (can be used more then once) and in Column
"B" external part number (Should only be used once, but, may be used
more then once)...  I am entering MTBF data in column "C" and would to
Count all rows in column with data, Except rows 1-527 Mar 2008 15:58 GMT4
I would like to count all of the rows in Column A that contain any text,
except Rows 1 through 5. I have the following formula, which worked, but
included rows 1-5.
=COUNTIF(Clients!A:A,"*")
Sick Time Reports27 Mar 2008 15:31 GMT1
I am trying to come up with a sick time report (very simple) that adds 4.0
hours of sicktime on the 1st and 15th of every month - and will allow me to
plug in time off and have it deducted.  Does anyone have this already?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.