| Thread | Last Post | Replies |
|
| Formula help req'd | 18 Jun 2004 14:28 GMT | 2 |
I am having trouble trying to display result. Basically say A1 has 10 in it and A2 has 5 in it A3 has the formula A3 =sum(A1-A2) {answer =5} What I want it do do is... say A4 displays HW as per the key.
|
| Sharing and Unsharing | 18 Jun 2004 13:39 GMT | 1 |
I am creating a spreadsheet to be used by multiple users on a network and set a workbook to be shared, then noticed I needed to make some changes. I tried to unshare this file and found I could not doe this. Is there a way or a different process for saving a file to be shared
|
| Summarizing Expense Sheets | 18 Jun 2004 13:27 GMT | 3 |
I have an excel worksheet to keep track of 5 different types of expense that occur each month. They are listed by the date they occur and I a given a total for all expenses. However, I need to know over the mont how much was spent for each type of expense.
|
| Search a string in all worksheets ? | 18 Jun 2004 12:11 GMT | 2 |
I am searching for a string say ABC in all worksheets in Excel 97. However, it seems that it only allows me to search it in the current worksheet. Is there any suggestion ?
|
| Help with a formula | 18 Jun 2004 11:40 GMT | 2 |
I am doing an assessment for TAFE and need some help doing a formula, so if there is anybody out there willing to help, I would really appreciate it. Using lookups, vlookups of If's - we need to work out the tax payable on the gross wage. Currently my gross wages are in Column H ...
|
| Searching for text | 18 Jun 2004 08:59 GMT | 2 |
Max helped first maybe again? :) I have a search that I want it to look for two separate values in the same search string. the search is embedded in an if statement like so...
|
| Why does Excel Print Perfect Circles - 'Oval'!! | 18 Jun 2004 08:40 GMT | 5 |
Perhaps someone has already found the answer to this problem but cannot find it and neither can the experts in a Computer Magazine. Excel 97 ~ 2000 insists on printing a perfect circle as an oval, cop the circle to Word and it prints as a circle. I have tried this o
|
| Does anyone know how to create a formula to sum up time sheet hours? | 18 Jun 2004 06:06 GMT | 2 |
I have a worksheet that has employees punch in times, punch out times and lunch out/in times. I am trying to create a formula that calculate the total amount of time worked. First I want to take time in subtract it by time out, then take th
|
| Writing Code | 18 Jun 2004 02:18 GMT | 1 |
I am a novice at writing code so I need help. I am trying to create an input box to pop up in an excel form and have the information that was put in the box to drop into a particular cell? Help!
|
| question about matrix formule | 18 Jun 2004 01:35 GMT | 3 |
let consider this (in cell A1 through B3): bob 10 bill 8 bob 5
|
| Table of Contents for Files | 18 Jun 2004 01:23 GMT | 2 |
Does anyone know of a way to populate a column with the names of files that exist in a folder? I would like to use this to create a table of contents for folders. ---
|
| Another suggestion, please | 18 Jun 2004 01:19 GMT | 8 |
I have a spreadsheet of addresses. Following previous assistance in this group, the sheet is sorted perfectly......nearly. The addresses are numerically sorted - 1 Anystreet, 2 Anystreet, 3 Anystreet etc. The house numbers are in separate cells from the road name.
|
| Run time error 91 | 18 Jun 2004 01:17 GMT | 2 |
I am such a novice at this....I have the following code that partiall works...(guess that means it doesn't work!) I can cycle through the first do while loop and then the code crashe with a run time error 91 -- Object variable or With Block variable no
|
| help to adjust this formula | 18 Jun 2004 01:00 GMT | 4 |
=VLOOKUP(A1,$J$1:$K$3,FALSE) I would like my search to not have a end is there a way to keep it open. when i add new patients to this list do i have to keep changing th
|
| Can't paste text into a Merged Cell | 18 Jun 2004 00:56 GMT | 1 |
I've just upgraded to Office 2003 and now I can't paste text selected from Word into a merged cell in Excel - is this normal or am I doing something wrong? Thanks
|