| Thread | Last Post | Replies |
|
| conditional formatting question | 15 Sep 2006 00:27 GMT | 1 |
I have a list of prices from 2 stores with same part numbers. I'd like to format the spreadsheet so if the part price from store 1 is higher than store 2 - make that cell Blue. The lower price (either store 1 or 2) should be Red.
|
| Pivottable with mulyiple input ranges | 15 Sep 2006 00:25 GMT | 1 |
Is anyone familiar with the fact that creating a Pivottable with mulyiple input ranges in Excel 2003 leads to a crash of the program? Who has suggestions on how to solve this crash? Ron
|
| Wrap text and templates | 15 Sep 2006 00:24 GMT | 3 |
I created a template that had some columns with wrap text turned on. When I save the document as a template and tried to enter data in worksheets based on the template, the row height would not change to show all of the text. Even though I turned on wrap text again
|
| Analyze Survey Questions | 14 Sep 2006 23:05 GMT | 3 |
Hi Folks - I need to provide counts and percentages of survey data. If Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many 1's, 2's, etc., plus calculate the percentage of the counts to the total number of answers.
|
| Find and Replace | 14 Sep 2006 20:53 GMT | 7 |
Hi Folks - I have a range of cells that contain a single "character". The character can be a digit or letter. I would like to prefix the contents of each cell with the word "department,", so that a cell containing a 5 would be replaced with department,5. Can this be done with ...
|
| How can I move Excel to my new computer? | 14 Sep 2006 19:44 GMT | 3 |
I bought a new computer. I have Excel 2002 (10.6501.6714) SP3 on my old computer. I need it on my new computer. How can I move it from my old computer to my new computer? Both computers are running Windows XP, Version 2002, Service Pack 2.
|
| Adding numbers in a column | 14 Sep 2006 19:14 GMT | 9 |
I've been noticing that Excel 2003 is incorrectly adding up the numbers in a column. Anyone know why this is and is there a fix for it?
|
| glossary of tems ? | 14 Sep 2006 18:08 GMT | 4 |
Where can I find a glossary explaining the terms used in Excel. The help menu assumes you know the meaning of all the terms.
|
| Huge File Size | 14 Sep 2006 17:41 GMT | 1 |
I have a problem, I have a 18 sheets, all of which are linked via an ODBC to SQL to pull in data, I thought that this was a good idea, now that it's done, my file is 42 MG, any suggestions on how to shrink it while leaving the links?
|
| Template for a small hotel | 14 Sep 2006 17:29 GMT | 5 |
does anybody know where I could find a template for managing a small hotel. Thanks in advance for ANY answer! Best wishes, Marc
|
| Average numbers from a lookup function | 14 Sep 2006 17:21 GMT | 4 |
I need to find the average GPA's from the Lookup function where I type in the letter grade and lookup changes it to the gpa number, but then I need to find the average...how do I do that? Bob from nowhere, help me again..... thanks
|
| Taking out domain names out of e-mail addresses | 14 Sep 2006 17:18 GMT | 1 |
In Excel I have a column with a few e-mail addresses. And I was wondering if it's possible to take the domain name out of the e-mail address and put them in the column next to it? Thanks,
|
| Transpose columns into rows | 14 Sep 2006 16:21 GMT | 1 |
Hi, I have some data in a table in columns which I need to convert into rows. This is specification data for some tools etc. The data is currently in the following format: Product No, order, description, value
|
| ALERT Pop up Box | 14 Sep 2006 15:00 GMT | 4 |
I am running a macro that calculates and produces several workbooks for a number of people. What I would like to do is have a pop up box appear on each of their computers just before the macro is ran to ask them to "Get out of their workbooks as the macro is about to be ran".
|
| count | 14 Sep 2006 14:34 GMT | 4 |
Hi - I'm hoping someone can help me - i have a list of employees (col A) who have been awarded $ amounts (col B). I need to count the number of times they have received an award... really would appreciate any help... thanks 00020084 1,500.00
|