| Thread | Last Post | Replies |
|
| Excel Versions Puzzle | 05 Jan 2005 22:54 GMT | 4 |
I seem to have more than one version of Excel in my machine. Some questions: * Is EXCEL 97 the same as EXCEL 8.0 * Why do I have a bunch of small files labelled Excel 4?
|
| Sum with conditions | 05 Jan 2005 22:34 GMT | 1 |
I've got a small problem. I have sheet with about 10 colums. I need to be able to sum a column with conditions tho Sum Column 1 if Column 2 has the letter "N" and if Column 3 is not blank.. Any Ideas??
|
| How do I do a Mail Merge in Excel? | 05 Jan 2005 22:26 GMT | 1 |
I'm trying to create individual sales invoices for multiple recipients. How would I go about doing a mail merge in Excel, or is there a better way to get the same results?
|
| COPY DISK TO EXCEL | 05 Jan 2005 22:03 GMT | 2 |
I'M TRYING TO COPY DIS TO EXCEL AND IT SAY THAT I CAN'T OPEN MY DOCUMENTS BEVAUSE IT IS A SHORT CUT?
|
| Link to a cell in another workbook by name rather than absolute c. | 05 Jan 2005 21:16 GMT | 2 |
I need to get data from a total cell in one worksheet into a cell in another worksheet. Because the source worksheet will have lines added to it, I wanted to reference the cell by its row and column label (e.g. "Jan Sales"), rather than by an absolute cell reference. I tried ...
|
| Comparing Excel Documents | 05 Jan 2005 20:44 GMT | 1 |
How do may I compare two worksheets the way you can compare documents in word, so that the differences are highlighted? Thanks HTH Brand
|
| Want to copy a cell down until it comes to the next nonblank cell, and then take this next nonblank cell until it comes to the next nonblank cell, and so on... | 05 Jan 2005 20:28 GMT | 2 |
First time post-er, please be patient! I've got an excel spreadsheet which I'm trying to put into a format that's easy to filter. Before I can do that, I've got to clean up the data in one column - I'm bound by how the data dumps from another tool.
|
| Macro Surprise | 05 Jan 2005 19:54 GMT | 1 |
I have used the same small, simple spreadsheet (XL8.0) for several years to track cash and prepare budgets. There is *nothing* complicated about it. But when I opened it this morning, a warning box alerted me to the
|
| HP statement | 05 Jan 2005 19:36 GMT | 1 |
I own a small musical instrument retailer in South Africa and have started running a few H.P. acounts for clients. I am looking for an excel spreadsheet that i will be able to send out to clients as a statement on a monthly basis. This sould indicate a running total owing etc. Can ...
|
| Tournament Brackets | 05 Jan 2005 18:59 GMT | 1 |
How do I set up a tournament bracket in Excel?
|
| Is there 'graph paper' in excel? | 05 Jan 2005 15:16 GMT | 11 |
Have been playing with column width and row heighth and border options to make graph paper. A bit frustrating. Best I can figure so far is 6.013 to 1.0 ratio for heighth to width for a square cell. Are there any ready made styles in excel. Thanks
|
| footer | 05 Jan 2005 15:15 GMT | 1 |
How can I get a footer (left or/and right leg) in line with a chart placed above? Many thanks for an answer in advance, Sophie
|
| Guide Lines | 05 Jan 2005 12:18 GMT | 1 |
Hi. After I exit page break preview to "normal View" my spreadsheet is left with a page outline/guideline which I find really annoying! How can I get rid of this if at all?
|
| Subtract time spent for lunch | 05 Jan 2005 04:34 GMT | 2 |
I have a sheet for my time at work. I want to subtract time for lunch. Col B is "In" to work Col C is "Out" finished work. Everything is on 24 hr clock, no am or pm. I would like a col D "Lunch" in minutes or fractions of hour.
|
| Help with Charting My Data -- | 05 Jan 2005 02:34 GMT | 4 |
Hello - I have a linked Excel chart to SQL Server that runs a query displaying various downtime information for our servers. I would like to display a chart that shows the percentage of "Uptime" for each server per month/year.
|