| Thread | Last Post | Replies |
|
| Adding time | 28 Nov 2007 15:36 GMT | 2 |
I want to add 847 minutes to 7:31 AM and get 9:53 PM. I have several rows of data : Start Time - formatted as 7:31 AM Duration - formatted as a number that equals minutes
|
| Lookup, match? | 28 Nov 2007 15:19 GMT | 6 |
I have a value in column A on sheet 3, I want it to match a value in column A in sheet 1, then I want the corresponding number from column c on sheet 1 to populate column c on sheet 3.
|
| lookup and sumproduct | 28 Nov 2007 15:13 GMT | 3 |
We have a data base that has columns such as start point, load point and unload point with the distance between each in a separate column. We want to create a column that will look up the load point and unload point and give us the distance. The problem is that the load point ...
|
| Excel | 28 Nov 2007 15:10 GMT | 4 |
I have a column of scheme codes, with the same codes repeated through the list eg. 123, 456, 123, 678, 456, 123 and a column of rateable values. I need to work out the average rateable value for same group of codes e.g. for all the 123 codes. Can you help please if this is ...
|
| Formulas-Making a number a standard amount of digits | 28 Nov 2007 14:58 GMT | 4 |
I am wondering how to make cells in a formula automatically 4 digits long? The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" & C15". If the C15 cell is say, "003", in the formula it comes out "3". I need 3 digits for the last part of the whole formula in the ...
|
| Links are different depending on how you open file. | 28 Nov 2007 14:44 GMT | 3 |
In Excel, using worksheets that are on the server and linked together, when is file is open, any file linking to it recognizes that it is open and drops the server name from the linked cell and refers just to the folder the file is located in.
|
| Adding a time stamp | 28 Nov 2007 14:38 GMT | 2 |
I would like to add a field that would state the time an action happened in another cell... ei. tell me the time a field went from 0 to 1 a static time... thanks
|
| How much I hate the ribbon | 28 Nov 2007 14:23 GMT | 6 |
There's an 'insert' command, and an 'insert', um, subribbon. The insert command is not on the insert subribbon. How does that even get through UAT?
|
| adding columns on different worksheets | 28 Nov 2007 14:15 GMT | 3 |
okay i have a workbook saved as "Bluesheet.xls." The first worksheet is titled "1" and the second worksheet is titled as "2." I need a (sum) formula that will add the totals on sheet 1 cells M41 to M54 & the totals on sheet 2 cells M13 to M54.
|
| IF, COUNTIF & AND STATEMENTS | 28 Nov 2007 14:08 GMT | 3 |
I have a COUNTIF formula which is searching for the number of activities which occur between 2 dates. This formulae works but I need to add to it. I have a reporting date (which is variable), I need the addition to only do the existing COUNTIF if the date above it it equal to or ...
|
| Copy Up until Non-Blank Cell encountered | 28 Nov 2007 14:02 GMT | 6 |
I need a procedure that will start with say cell L300 (which has a text value) and Copy it into cells L299-L250 that are blank; L249 has a different Cell value and I need to copy it into cells L248-L150 that are blank, etc until Row 2.
|
| Excel, Macro, Drop down list | 28 Nov 2007 13:15 GMT | 10 |
I have a list that I want to make into a drop down list that when each individual item is selected, cause a macro to run. Can anyone assist?
|
| How do I insert a spinner (spin box) in Excel 2007? | 28 Nov 2007 13:05 GMT | 1 |
I am familiar with spinners and their use in Excel 2003 but can not find ANYTHING in Excel 2007 re. 'forms toolbar' 'spinner' or 'spin box'. Can anyone guide me to this little gem or is it lost and gone forever?
|
| 2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)" | 28 Nov 2007 12:42 GMT | 3 |
I would like to use this keyboard short cut as I did in previous versions of excel - help!
|
| Adding months to date at end of month | 28 Nov 2007 12:30 GMT | 4 |
I have searched but can't see this specific question. Basically the question is how to add moths to a date, i need to have a column that has column F's dates + 10 months. However, the column F dates are all month end days, so 31/8/07 or 28/02/06 or 30/06/07.
|