| Thread | Last Post | Replies |
|
| Auto generate sheets by different values of a cell. | 19 May 2008 04:30 GMT | 4 |
I have a sheet in excel ,with the following fields Name, gender…,city. I want to use excel to auto generate sheets according to the value of the field city.
|
| CAn Autofilter be used to hide different columns? | 19 May 2008 04:26 GMT | 1 |
I have an excel with rows as area and skill levels.Columns contains names. I need to get a particular area and different skill levels. I can use auto filter to select the correct area. But then my columns are not filtered and I get the entire list of names around 200 names. But I ...
|
| Trouble launching Excel & Access | 19 May 2008 04:22 GMT | 2 |
When I install 2gig ram (2 x 1gig) on my PC I can no longer open an excel attachment from an Outlook email. Excel launches but shutsdown as soon as the file opens (takes a while). If I open excel first the file will open. I also have a problem launching any Access db. Access ...
|
| Calculate a quarter | 19 May 2008 04:15 GMT | 7 |
I have a large spreadsheet that is a five-year forecast. In one column is a date, I need to know a way to calculate the quarter, in XQYY format, the event is forecasted to happen. Where X is the quarter from the table below, Q is a set value and XX is the forecast year.
|
| sum a column within a name definition | 19 May 2008 03:30 GMT | 7 |
I have several names defined for different cell ranges and I would like to be able to sum up the values in Column C within a particular name definition. For example, if a name is defined for range A2:J13, I would like to be able to sum up column C's values without have to ...
|
| 1st smallest, 2nd smallest,3rd smallest | 19 May 2008 02:16 GMT | 8 |
I have a list of numbers in A1 to A5 4 4 5
|
| Finding 1st,2nd,3rd etc | 19 May 2008 00:38 GMT | 5 |
NAME AMOUNT MAX 20 CLIFF 5 CLIFF 38
|
| Can't find project of library | 19 May 2008 00:06 GMT | 3 |
I've developed a spreadsheet with macros in an older version of excel. When I bring it into a newer version of excel, the macros fall down immediately with the following error message: Compile error: Can't find project or library. Is there a way of automatically loading the ...
|
| extract data from a range based on other cell's input | 18 May 2008 22:06 GMT | 1 |
Hey there, Not the best at wording but here it goes... I have a 2-column 12-row range of data. One column is a description, the other is a value of currency.
|
| get more pages on exel | 18 May 2008 22:02 GMT | 1 |
got pages 1, 2 and 3, but how do I create page 4,5,6 and so on
|
| Keeping value the same across worksheets | 18 May 2008 21:12 GMT | 3 |
I have a worksheet of master data. I want any information in A3 to always be in a different worksheet called phone directory. If I insert a row in master data the cell in phone directory automatically changes to A4. My formula is ='Master Data'!$A3. Inserting row changes to: ...
|
| how can I clear a formula? | 18 May 2008 20:37 GMT | 5 |
I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out?
|
| How do I remove an embeded flash object from a spreadsheet? | 18 May 2008 17:34 GMT | 1 |
I pasted a web page into a spreadsheet, then when I tried to remove it I could delete all except the flash objects. How do I remove them?
|
| selecting cells - Problem | 18 May 2008 16:35 GMT | 2 |
So when I select the cells with the mouse, I can't stop the selecting from occuring...For example I want to select 16 cells. I left click on the mouse and start moving the mouse around to cover the cells I need..no problem there. Then, I try to right click again, but the mouse ...
|
| Why did my Excel Checkbook stopped totaling after 30 entries??? | 18 May 2008 16:14 GMT | 5 |
I downloaded the Excel checkbook template, and after 30 entries it stops doing the total for me. I see it is shaded down to number 30, and I don't know how to keep this going. Anyone have any ideas?
|