| Thread | Last Post | Replies |
|
| automatically updating imported statistics | 24 Feb 2008 15:16 GMT | 1 |
I have imported NBA Basketball stats from a specific site to a spreadsheet. When the stats change on the specific site, is it possible to have the same change made automatically on my spreadsheet? Example: What must I do to make the Won/Lost record for each team change
|
| not understand | 24 Feb 2008 14:18 GMT | 1 |
Column A Column B C D E Question1 Question2
|
| Help Designing Quality Spreadsheet | 24 Feb 2008 12:21 GMT | 3 |
I need to design a spreadsheet that I believe is a little over my head. I have a list of quality scores from a call center as follows: Agent Score Supervisor Bill Smith 89 Jack Rodgers
|
| macro to all workbooks | 24 Feb 2008 11:47 GMT | 1 |
is there possible to create a mocro for all excel work books.
|
| Does ?? act as a wlidcard? | 24 Feb 2008 09:21 GMT | 5 |
I've had a very basic formula return results I just cannot understand. It's a simple COUNTIF(A1:A1500,C5) C5 contains a text string. The range A1:A1500 contains people's initials i.e JO, AL, MC etc..
|
| Cell Formatting | 24 Feb 2008 08:36 GMT | 3 |
If I format cells (using the format cells dialog box>Custom) as : +0;-0 when the value is zero it shows as +0. Is there any way to have negative numbers as -X, positive numbers as +X and 0 as just 0.
|
| Counting | 24 Feb 2008 06:48 GMT | 4 |
Hello all! I am a teacher and I am trying to calculate what each student scored on a test. Here's my setup: Column A Column B C D E
|
| How do I put movie titles in alphabetical order | 24 Feb 2008 02:12 GMT | 3 |
I want to put all my movies that I have into a folder and then have them in alphabetical order so they will be easy to find. I'm new to using any of these programs. Just installed Office 2003 Basic. Any help would be greatful, and please put in easy to understand
|
| Expanding cells | 24 Feb 2008 00:50 GMT | 2 |
Is there a way to have a cell expand automatically as text is added so the entire text shows without having to manually adjust cell size?
|
| 0987 show in the cell - the zero drops off-ned all 4 digits | 23 Feb 2008 23:09 GMT | 2 |
I type in 0987 in the top bar and yet I press enter the number in the row cell shows 987 and the top bar no longer has the zero. I looked at format and i have tried number , general, custom etc -- HOw to get the zero and all four digits to show?
|
| Custom date Calculations | 23 Feb 2008 22:40 GMT | 4 |
I would like to calculate the age in months between 2 custom date codes. The date code format is as follows: 10804Where the 3 most significant digits = year, in this case 2008, and the 2 least significant digits = week of the yearin this case 04. The highest possible week code is ...
|
| Multiple Min & Max range lookup. | 23 Feb 2008 21:24 GMT | 3 |
I have a list of Mins, and a list of Max's. If someone was to enter in a number in D3, I would like for it to lookup the entire list of Mins and Maxs to see if the number entered falls within range of a Min-Max row.
|
| hide & unhide sheets in excel 2007 | 23 Feb 2008 20:34 GMT | 1 |
Hi.. i have a workbook with lots of sheets. I have a main sheet and other supporting sheets. I want to have a drop down list in the toolbar (only for this workbook) so that user can select which sheet he wants to view.
|
| Min & Max Range Lookup | 23 Feb 2008 18:13 GMT | 5 |
I have a number in cell A1 (50) I have a larger number in B1 (100). What formula can i use to search these two values as if they were min and max, and return a word if found. Example:
|
| LOWER and SUBSTITUTE all non-alpha characters in column with a hyp | 23 Feb 2008 18:01 GMT | 6 |
Occasional Excel 2000 user, can anyone please show me how to LOWER and SUBSTITUTE all non-alpha characters in column with a hyphen (in Run Jane, see Spot jump)? : ) Thanks, Jerry
|