| Thread | Last Post | Replies |
|
| Autofilter updating automatically | 21 Nov 2007 00:36 GMT | 2 |
I have an autofilter that checks on a Planning Board and is set to filter out non-blanks. When the Planning Board Updates the autofilter is not updating automatically to show that a new entry has been made on the Planning Board.
|
| Sumproduct? | 20 Nov 2007 22:39 GMT | 19 |
Hello world, I am working with a xls log function in a filetransfer workflow. The worksheet is like this: Date/Time Job name Files in job
|
| today | 20 Nov 2007 20:27 GMT | 6 |
Hi I was wondering if there's a way to add today's date statically (so it won't auto update) to a cell inside a formula. I would like the cell to enter today's date automatically when a value is placed in cell A:12, something like this;
|
| acesses to oxycontin | 20 Nov 2007 19:36 GMT | 2 |
hi im 38 m work for heavy equiptment company. had accident 4 years ago been in pain every sience ive tried lots of drugs to help ease daily occurrences i found 1 40 oxy at night and ne in morning works just fine.problem is cant get dotor to write a 3 month supply,lessons the cost ...
|
| Quick conditional formatting question??? | 20 Nov 2007 18:45 GMT | 2 |
I want the number in a cell to be green if it is equal to or greater then .50 and red if it is below .50. I can use conditional formatting to make it green if it is equal to or greater then, but how do I also make it red if it is below .50?
|
| How do I calculate age from a birthdate in Excel 2002? | 20 Nov 2007 18:03 GMT | 1 |
I have a list of 3600 birthdates and I need a formula to calulate ages.
|
| "starting a new line in the same row in excell" | 20 Nov 2007 16:51 GMT | 1 |
i need help on this question thanx
|
| Dual Filter | 20 Nov 2007 15:20 GMT | 3 |
Hi peeps. I am seriously computer illiterate. I have two columns in Excel. One shows names with only 7Y entered in one column , and some have 7Y in the same column but also 7YY in another column.
|
| comparing columns | 20 Nov 2007 14:44 GMT | 2 |
I have a master Excel worksheet, which has six columns:- C:D:E:F:G:H and there are approximately one thousand rows. On a daily basis I import data into Column A. of this master worksheet. The data consists of lots of different 10 digit numbers, so I have a different 10 digit ...
|
| would like to buy microsoft excel 2007 WORK BOOK | 20 Nov 2007 14:22 GMT | 1 |
would like to buy microsoft excel 2007 WORK BOOK
|
| How to add text, i.e., " -- Week: _________" to the formula in this message? | 20 Nov 2007 14:00 GMT | 5 |
Because of a unique but complicated requirement, custom formatting a cell with yyyy" -- Week: _________" didn't work anymore. But I fixed it by using this in the cell formula
|
| How to do master detail in excel | 20 Nov 2007 13:50 GMT | 3 |
I have a master/detail style database. For example, Master table: id, name, address 1, jerry, 17 avenue
|
| Slow Saving in Excel | 20 Nov 2007 12:43 GMT | 2 |
I have developed a spreadsheet to track daily production. The size of the workbook is 16.2MB. The save time is very poor. Is there any way I can speed up save times or improve the sheet to save faster?
|
| Autofilter Automatically Update | 20 Nov 2007 12:38 GMT | 1 |
I have an autofilter that checks on a Planning Board and is set to filter out non-blanks. When the Planning Board Updates the autofilter is not updating automatically to show that a new entry has been made on the Planning Board.
|
| Counting Unique Data | 20 Nov 2007 12:34 GMT | 3 |
Is there a way to count the unique number of items in a column? If you have something like the following: x 4
|