| Thread | Last Post | Replies |
|
| Problem referring to "names" in formulas across sheets | 18 Feb 2006 23:36 GMT | 5 |
Hi Excel - experts! I'm somewhat baffeled: On sheet 1 I have defined a "name" for cells A3:A500 as "AllDays". On sheet 3 I have a formula using this name: =SUBTOTAL(9;AllDays)
|
| How can I track meeting attendance? | 18 Feb 2006 23:27 GMT | 3 |
This is probably something simple, but I'm such a novice I don't know where to start. I want to track my attendance at monthly meetings. I have five defined (don't know if that's the right term) plus numerous miscellaneous meetings I attend every month. I would like to be able to ...
|
| Hyperlink | 18 Feb 2006 22:28 GMT | 13 |
This is probably a simple question but its been a while. I want to format a cell to display the url of a hyperlink in another cell eg A
|
| how to converts a number to text eg. "2" become "two" | 18 Feb 2006 20:25 GMT | 3 |
how to converts a number to text eg. "2" become "two"
|
| Help with Count Please | 18 Feb 2006 20:05 GMT | 8 |
I need the correct formula to count the following A B 1 5 FW 2 3 G
|
| Help please | 18 Feb 2006 19:36 GMT | 1 |
I m using ivoice in excel xp. Is there any way that after printing invoice its data can be stored in another worksheet. RRS
|
| Help with Excel Formula | 18 Feb 2006 19:23 GMT | 4 |
I have been given the task of updating our hrly tracking of employees at my job. We have lovely excel sheets that do this, however we have old ones that convert the time from hrs and minutes to hours and two decimal places. We put them into a new spreadsheet (why? I don't know!)
|
| Count | 18 Feb 2006 19:18 GMT | 1 |
I need the correct formula to count the following A B 1 5 FW 2 3 G
|
| Count | 18 Feb 2006 17:28 GMT | 1 |
I need the correct formula to count the following A B 1 5 FW 2 3 G
|
| Nested SUMIF? | 18 Feb 2006 16:37 GMT | 2 |
Hi I have a table with data; date, type, discription and value. In a separte sheet im trying to sum up data from this table depending on the variables. I know that SUMIF can sum up all values depending on i.e. type value matches the choicen variable. Or I can use DPRODUCT if
|
| mail merge ticket numbers | 18 Feb 2006 15:55 GMT | 2 |
Here is one for all the guru's out there... I have created a set of 3 "tickets" on a single page in MS Word. I have created a list in Excel from 101-201. How can use the mail merge in MS Word to show the sequence ticket
|
| How do I quickly enter the same number into different cells? | 18 Feb 2006 14:26 GMT | 2 |
I am entering a "1" into various cells (collating answers from questionnaires). Is it possible to fill the cell with just a mouse click rather than having to type in number 1 each time? Many thanks for your help. Mel
|
| Pasting multiline text into a single cell - how? | 18 Feb 2006 14:25 GMT | 3 |
I have some text in a PDF file. The text is split over two lines in the PDF The text reads Candidates should understand the relationship between hardware and
|
| ubdate | 18 Feb 2006 13:40 GMT | 1 |
|
| Need to obtain sum of last X entries that are greater than 0 | 18 Feb 2006 11:51 GMT | 2 |
Extreme thanks in advance... A1=20 A2=40 A3=10
|