| Thread | Last Post | Replies |
|
| I need an Excel formula for converting hours to days? | 27 Oct 2006 20:26 GMT | 4 |
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 disappears | 27 Oct 2006 19:14 GMT | 1 |
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 versa | 27 Oct 2006 18:54 GMT | 3 |
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 selection | 27 Oct 2006 18:45 GMT | 1 |
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 GMT | 2 |
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 Question | 27 Oct 2006 17:51 GMT | 2 |
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
|
| Transposing | 27 Oct 2006 17:13 GMT | 2 |
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 Range | 27 Oct 2006 16:32 GMT | 2 |
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 edit | 27 Oct 2006 16:28 GMT | 2 |
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 Tab | 27 Oct 2006 15:43 GMT | 6 |
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 GMT | 4 |
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/A | 27 Oct 2006 14:55 GMT | 4 |
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 GMT | 6 |
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 columns | 27 Oct 2006 13:59 GMT | 2 |
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 spreadsheet | 27 Oct 2006 13:55 GMT | 2 |
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
|