| Thread | Last Post | Replies |
|
| How do I delete the header in my worksheet? | 28 Mar 2007 03:04 GMT | 3 |
I used the blank for header instead of footer and now cannot delete the header portion on my worksheet. What do I do next?
|
| Does Excel 2003 have CDF feature in its histogram plotting function? | 28 Mar 2007 03:02 GMT | 3 |
Does Excel 2003 have CDF feature in its histogram plotting function? Here CDF means "Cumulative Probability Density Function", We know that histogram is actually discretized version of PDF, which stands for "Probability Density Function".
|
| Excel can not multiply? | 28 Mar 2007 03:00 GMT | 12 |
I am working on a new spreedsheet and wanted to multiply the total of 22 columns by a constant. No mater what constant I put into the formula =SUM(E53* ) Excel gives me the wrong answer. Now I have cleared contents in every cell thinking it may be something left over but that ...
|
| Pausing Macro | 28 Mar 2007 03:00 GMT | 2 |
In Excel, where can I get examples for Macro's that pause for input, then continue?
|
| Column headers are numeric | 28 Mar 2007 02:19 GMT | 1 |
All my column headers are now numbers instead of letters ...HELP !!!!!!! thanks
|
| Complicated formula | 28 Mar 2007 02:08 GMT | 6 |
I have an Excel sheet with probably 1200 cells. Each cell may contain a character which represents a numerical value (ex. P = .75, R - .50, etc.). Certain letters represent a higher value, and I want the higher of the two values. How can I compare every cell and arrive at a ...
|
| shared workbook update interval | 28 Mar 2007 02:07 GMT | 1 |
I have a shared workbook which i need to have updating every minute, however the minimun time allowed under tools\shared workbook\advanced\update changes every is 5 minutes does any one know of a way that i can change this to allow automatic updates more frequently.
|
| Copy/Pasting formulas | 28 Mar 2007 01:56 GMT | 2 |
My formula is =PH1!A25 for one cell on my worksheet. I need the same formula in the other cells in my column. When I do that I get the following in the cells I pasted to.... =PH1!A26
|
| Excel 2007 - files open slowly | 28 Mar 2007 01:23 GMT | 19 |
Having a strange issue with Excel 2007. When I open an Excel file (.xlsx or .xls) by double-clicking the file it takes forever to open (about 60 seconds). If I have an instance of the Excel application open already, then double-click the file, it opens right away. The problem
|
| How do you group data in a Pivot Table? | 28 Mar 2007 01:20 GMT | 1 |
Sorry, this is a really basic question but I'm only new to Pivot tables. I am trying to calculate the frequency of some data and I have some ages in a pivot table that i want to group but when I click "group" another column with the heading "Group1" appears with no data in it.
|
| cell names | 28 Mar 2007 01:17 GMT | 1 |
I have a sheet with a column of numbers. Each cell in the column that contains a number is named. I want to transfer these numbers to a column in a second sheet so that each cell in the second sheet references the cell name from the first sheet, allowing any changes in the first ...
|
| The opposite of the "sort" function | 28 Mar 2007 01:10 GMT | 3 |
I have a list of alphabetically ordered data in a column. Is there a function for randomizing the order of these data?
|
| Sum according to font colour | 28 Mar 2007 01:06 GMT | 4 |
Is there a way to sum a range of values according to the colour of the value? e.g. sum all where colour = red, etc. Thank you in advance,
|
| Macro giving different results each time it is run - bugs maybe !? | 28 Mar 2007 01:04 GMT | 1 |
A month or so ago I created a macro by recording and saved it and have been using it well. Until recently the results have been incorrect. part of the macro is sorting the different products into groups and for some reason it is doing this incorrectly. Every time I run the ...
|
| function returning Text to cell | 28 Mar 2007 00:36 GMT | 1 |
First thanks for taking the time to help a poor soul out. Here is my issue. I have a list of vendor names. The vendor names are some what of an abbreviation of the actual name. I want to write a function that will
|