| Thread | Last Post | Replies |
|
| Displaying Drop down list items based on selection of another colu | 18 Feb 2008 14:15 GMT | 3 |
Good Morning!! I am running Excel 2003. Is there a way to display items from a dropdown list based on what is selected in another column. For example... Column D has a list of Work Flow's in it and Column E has
|
| Coding data | 18 Feb 2008 13:16 GMT | 2 |
I have compass bearing wind direction forecast measurements with an accuracy to one degree. Which is being compared to obserevd wind directions which is recorded in the 16 points of the compass. Using EXCEl 2007 I need to convert the forecast into the same format with
|
| How do I connect two worksheets together? | 18 Feb 2008 12:46 GMT | 7 |
I'm trying to connect two worksheets together whereas the input into a cell of one will influence the outcome in the cell of another. EX: Inputting 300 in a cell of the first sheet will give me an answer in a cell of the second sheet, less 15%.
|
| F1 and F2 keys desactivated | 18 Feb 2008 11:35 GMT | 6 |
My F1, F2 and other F functions keys are desactivated. Could you tell me how to activate them again. Regards
|
| countif with cell ref vs fixed number... | 18 Feb 2008 11:07 GMT | 5 |
I am trying to use countif to establish whether a range of cells have a value greater than or equal to a number in another cell - the number is 21.8% and lives in cell C4 this formula works fine =COUNTIF(C16:R16,">=21.8%")
|
| Stopwatch time | 18 Feb 2008 08:03 GMT | 2 |
How can I enter stopwatch (or elapsed) time into cells in the format of x:yy.zz where x is minutes, y seconds (0-60) and z is hundredths of seconds (i.e. 0-100). I would like to show the actual time in the cell and then be able to chart these times. This will allow me to compare ...
|
| Updating linked cells within a workbook, from worksheet to workshe | 18 Feb 2008 01:15 GMT | 7 |
(Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it. Many of the sheets contain cells that refer to values in other sheets. I recently found that some of the values were incorrect (I believe they were just not updated). When I double clicked on the cell, ...
|
| Can't get Forms option bjuttons into a Group box | 18 Feb 2008 01:09 GMT | 3 |
I want group option button so I am trying get a group of option buttons into a group box unsuccessfully. This is what I tried unsuccessfully. I tried selecting the Group box and dragging and dropping the option buttons
|
| numbers won't autofill | 18 Feb 2008 00:44 GMT | 2 |
numbers, (1,2,3) won't autofill for me in my excel. Everything else does, like Monday, Tuesday, Wednesday, and 9:00, 10:00 11:00, but if I type in "1" and autofill, all I get is more one's. Help??
|
| Changing Cell Background Color Depending on the Number | 18 Feb 2008 00:41 GMT | 1 |
I recently asked a question on how to Count the days a person works even though there is a formula in the cell and was given =COUNTIF(F4:L4,">0") By WLMPilot which works wonderfuly. Now I would like to know if there is a way for it to automaticly change that
|
| count days | 17 Feb 2008 23:16 GMT | 2 |
I have a list of 41 dates employees can possibly work. I need to calculate how many days each employee worked of the 41 dependant on their start date. so I can work out a percentage of days worked. So if employee john started work on the 1st day and was still employed on the ...
|
| Customized Formula | 17 Feb 2008 22:51 GMT | 7 |
I'm in need of a very specific formula please. A1 to A100 are all different dates as 02/17/08 ( m,d,y) (could also omitt the year) B1 to B100 will be formulas ( of course I just need B1 formula so I copy it
|
| Can I randomly select values from an array with removal? | 17 Feb 2008 22:49 GMT | 2 |
I am trying to set up a random value generator with removal of the selected values. Is there a way to accomplish this?
|
| web query will not fill down formulas | 17 Feb 2008 22:28 GMT | 2 |
In Excel 2003 I have had a web query working for several years pulling down currency rates from msn. Previously, it also filled down formulas next to the data that came in from the web. Now, however it seems the table dimensions have enlarged because it deletes
|
| Remove grouped items and fields from pivot table | 17 Feb 2008 22:06 GMT | 1 |
When items are grouped a new field with new items are created. Is it possible to remove them completely without redefining the data source for a new pivot table?
|