| Thread | Last Post | Replies |
|
| Macro Question | 25 Aug 2006 19:40 GMT | 1 |
I am using this: Sub Macro8() Range("G6").Select Selection.Copy
|
| wrapping text and vlookup | 25 Aug 2006 19:24 GMT | 4 |
Bit of a strange one this, I have a vlookup formula that returns long text strings. I'd like to have the cells wrap the text when necessary, however excel won't apparently allow this to happen - with the wrap text box checked the text doesn't wrap. Does anyone know if this is a ...
|
| How do you suppress duplicate lines? | 25 Aug 2006 19:13 GMT | 4 |
I am combining mailing lists from different sources and I need to delete any duplicate entries, is there an easy way to do this in excel?
|
| Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells | 25 Aug 2006 18:55 GMT | 2 |
I have a worksheet that I am trying to calculate the a rolling average of the last 10 days of activity for manhours/tons of steel. Each worksheet is 1 month of data Row 1: I have days of the week
|
| how to merge many cells to one cell with keeping all data | 25 Aug 2006 18:51 GMT | 4 |
I meet a question about following. in A column, there are many data(some data are same), and in B column, there are many relevant data, but they are different, how to merge all the revelant data to one cell in B column with the same in A column,
|
| Annualized rolling (moving) average | 25 Aug 2006 18:45 GMT | 2 |
I am using the following formula to calculate an average of data for a rolling 365 day period. Column A is the date, column B is Data =((SUMPRODUCT(--($A$1:$A3<$A3),--($A$1:$A3>=$A3-365),($B$1:$B3))))/(SUMPRODUCT(--($A$1:$A3<$A3)*--($A$1:$A3>=$A3-365))) Is there a simpler way to ...
|
| DMAX wrong calculation | 25 Aug 2006 18:43 GMT | 3 |
I am using Excel 9.0.7616 SP-3. The calculation is very simple =DMAX(H3:H18,1,H3:H18), even though all cells in that small database have numbers the result says "0". All those cells have different formulas to calculate values from another cells. If I remove all
|
| Configured cell that looks like a combo box. | 25 Aug 2006 18:35 GMT | 3 |
I have a sheet that I am trying to edit that was created by a person that is no longer with my company. The cell looks like a regular cell until you click on it and it opens up a list with a scroll button. I have tried to edit the cell so that I can place more items into the the ...
|
| Insert spaces in String of Numbers | 25 Aug 2006 18:32 GMT | 1 |
Hello, I have a series of 16 numbers and would like to insert spaces or dashes. Is there a formula that can be used to accomplish this task. My number appears from the report as: pp234567890123. I would like pp2-345-678901-23. Thanks for your time.
|
| month formula | 25 Aug 2006 17:54 GMT | 3 |
A question - if I type in the date 14/12/2004 and in the column next to it use the month formula with the cell format set to general it correctly returns 12. However if I want it to show say Dec I went to custom typed in mmm and it always returns Jan.
|
| 12ths denominators for fractions in Excel (for pension calcs) | 25 Aug 2006 17:13 GMT | 1 |
As a pensions administrator, I use Excel to display pensionable service in years and complete months. The ability to express service in terms of years and twelfths of a year would be useful. This is not one of the options for fraction formatting.
|
| Searching for a value in an Array | 25 Aug 2006 16:53 GMT | 16 |
I have a master price list were I have in column A the country name, and in column B the machine model number and in column C the price. Obviously you can find the same machine for many countries with different prices, I need a formula were I can extract for a certain country the ...
|
| How do I apply conditional formulas across multiple columns? | 25 Aug 2006 16:49 GMT | 2 |
Say my data set looks like this: A B C Molly April Candy Sally April Candy
|
| Rows to repeat at top... ON SCREEN | 25 Aug 2006 15:21 GMT | 3 |
I have a spreadsheet formulated to print the repeat rows at the top. I want them to show on my screen so that I know which column that I am typing in. Is this possible?
|
| HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES? | 25 Aug 2006 15:17 GMT | 1 |
I have a spreadsheet with calculations that may result in a zero balance. How do I automatically delete all rows with a zero balance?
|