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 / October 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
I need an Excel  formula for converting hours to days?27 Oct 2006 20:26 GMT4
A1            A2            A3
18:15:00    22:00:00    4:15:00 PM
18:15:00    22:05:00    4:20:00 PM
                     total    2:50:00 AM
bottom sheet tab disappears27 Oct 2006 19:14 GMT1
bottom sheet tab disappears, the bottom scoll bar that goes from side to side
how do we get it back to use?
thanx kai
FirstName, LastName and vice versa27 Oct 2006 18:54 GMT3
In columns X and Y of Sheet X, I have a list of names and numbers:
James, Lebron      82
O'Neal, Shaquille  80
Wade, Dwyane     79
How do I get drop down pick list comments to appear over selection27 Oct 2006 18:45 GMT1
I have created drop down pick lists in excel sheets, and would like to be
able to hover over the selections and display comments/definations for each
pick list selection.
Quick help needed...27 Oct 2006 18:33 GMT2
  I've been reviewing many entries in the forum to help me complete a task
I signed up for.   Although I have learn much from the many responses I still
haven't solved my specific problem.   I'm sure I could if time permitted but
now I'm under the gun to complete.   I have a ...
Quick Question27 Oct 2006 17:51 GMT2
I wanted to know if there is a function(s) to help me.  
I have data specified by days of the week (row), and then departments
(column).  The data represented is total people in each department per day.  
I want to find the highest # of people for the week, but only using each
Transposing27 Oct 2006 17:13 GMT2
I have a spreadsheet that contains 45 rows and 90 columns. I need to make the
rows into 45 columns and the columns into 90 rows.
Help With Dynamic Range27 Oct 2006 16:32 GMT2
I am not sure if what I want can be done with a Dynamic Range.  The formula
below works great for capturing anything within the range that is "CCLS",
however I now require the formula to look down ColumnA and ColumnI, and
anything that matches "Actual" in ColumnA and anything ...
Locked Cell - can still edit27 Oct 2006 16:28 GMT2
Good morning all,
i have a workbook whhere i want to lock most of the cells.
Have selected all cells in the sheet, gone format > protection > select
locked, then tools > protection > protect sheet.
Take a Cell and add it to the Footer or Tab27 Oct 2006 15:43 GMT6
I am trying to be able to take a cell that contains someone's name and either
have it automatically placed in the Footer of the document or have it be used
to name that Tab (for ease of finding which spreadsheet belongs to each
employee).  Can either of these be done?  I've tried ...
Can excel give value in words of number entered in another cell?27 Oct 2006 14:57 GMT4
I entered the amount 125 in the cell A1.  I want excel to convert the value
in number (digits) to words "ONE HUNDRED TWENTY FIVE" in another cell, say
A2. The value in words should change automatically when I change the amount.  
Is there any formula for this? can any one help?
Vlookup with #N/A27 Oct 2006 14:55 GMT4
How do I write a vlookup that works for n/a
IF(F45=--#N/A;1;0)
Above one does not work
br
OTHER EXCEL FUNCTION COUNTER SOLUTION ?27 Oct 2006 14:21 GMT6
IN REFERENCE TO A SUGGESTION THREAD TITLED "Excel 2003 SP2 computes the power
of a negative number wrong", I kindly request your help to reestablished
confidence on engineer´s excel workbooks:
I NEED A FIND/REPLACE COMMAND FORMULA....
separating data in columns27 Oct 2006 13:59 GMT2
Hello.  I have a worksheet with several columns of information.  What I need
help with are only two of the columns.  One column lists the number of
vacation hours available for each employee of our company.  The other column
is their rate of pay.  Both columns have been ...
flipping a spreadsheet27 Oct 2006 13:55 GMT2
Hey folks,
My company's invoicing program outputs data to an Excel spreadsheet
with the following header row:
Line Item Type, Customer Name, Invoice #, Invoice Date, Amount
 
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.