| Thread | Last Post | Replies |
|
| Copying Headers | 25 Mar 2008 21:39 GMT | 1 |
How do I copy the headers from one sheet to another? JP
|
| I WOULD LIKE TO CHANGE "." FOR "," IN EXEL FILE, CAN YOU HELP ME? | 25 Mar 2008 21:36 GMT | 4 |
I am searching any formule or option to change "." for ",". I have receive a document which show the decimals as "." and I need to change to "," to can to add.
|
| Combine Text from 2 columns into 1 | 25 Mar 2008 21:34 GMT | 3 |
Is there a way to move text from column B and paste or insert into column A behind existing text; without retyping?
|
| Entering/Formatting Time in Cells | 25 Mar 2008 21:32 GMT | 13 |
I'm trying to enter numbers as running times. For example, when I enter 3:55, I want it recognized as 3 min. & 55 secs.; Not 3:55 a.m. It should be simple, but I can't seem to find the right format function. Can anyone tell me what I'm missing? I don't want to enter it as ...
|
| Counting Unique Values That Are Separate by Commas in a Column | 25 Mar 2008 21:06 GMT | 2 |
I have a column like so, with each text line equalling a cell (the names are U.S. Counties; 11 cells are below, excerpted from my dataset of around 600 rows): Mobile, Baldwin
|
| Lookup data | 25 Mar 2008 21:00 GMT | 3 |
I want to populate a table by referencing a cell range from another worksheet, for example, if i type a name in a cell of worksheet1 i want to reference all the information corresponding to that name from a different worksheet
|
| Lookup that returns vector(array) | 25 Mar 2008 20:50 GMT | 3 |
I have on eproblem. I have a table that contains two columns. One is type of product(I have 6 different products)and another is quality characteristic for those products. I need some function that can look at the first column and returns vector with the values just for one type ...
|
| Conditional Format | 25 Mar 2008 20:47 GMT | 3 |
I have three 10x10 tables and each have different values for the same item. So all in all, there are 100 items with three values each. So for example, the item in in the first column, first row of table one is the same as the item in the first column, first row of table 2 and ...
|
| Macro to go to A1 Cell | 25 Mar 2008 20:34 GMT | 3 |
I have done this before, but cant recall how its done. I want to create a button with a macro on it, so when I hit the button, the highlighted cell will be the A1 Cell. I know I need to create the macro first; thats the problem I am having right now.
|
| Highest 3 in 10 Based on Consecutive Cells | 25 Mar 2008 20:28 GMT | 2 |
I have a series of columns which hold salary data for a few hundred employees which is recorded by date. I need to work out what the average salary is for the highest three consecutive (i.e. cells immediatly adjacent) years in 10 e.g.
|
| Applying a macro to a command button, Excel 2002 | 25 Mar 2008 20:05 GMT | 3 |
I have done this in 2003. Create a command button, macro list appears (or right click and assign macro) In 2002 I dont see the same options. I was able to create a regular rectangle shape and apply the macro to that. Any thoughts?
|
| Auto-Sort Won't Sort All Column Cells | 25 Mar 2008 20:00 GMT | 1 |
Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The spreadsheet has several columns which sort easily, but the last column will only sort a select tiny block of cells. Is there a way to correct this so the Auto-Sort will sort the entire column? Many ...
|
| Graphing cyclic data | 25 Mar 2008 19:53 GMT | 6 |
I have a single column of cyclic generated data. The cycles are over time but are not always consistent . Though it is very easy to generate a graph of the cycles, I am trying to pull out ONLY the minimums and maximums of each cycle for graphing, each its own data series. The ...
|
| hidden result | 25 Mar 2008 19:44 GMT | 1 |
in one complex Excel 2003 application some formulas stopped to show their results. Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10)) the formula remains written instead of disappearing and formatted like if
|
| wrong cell addresses | 25 Mar 2008 19:33 GMT | 4 |
Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the columns are incorrect. Is there some option that accidentally got switched?
|