| Thread | Last Post | Replies |
|
| text function question | 15 Sep 2005 07:27 GMT | 1 |
Hopefully my confuse is not so difficult to help. I have text arrays in column A2:A100 (much datas) which are filled with "n" and such as "loose end", "soft". I want in the column A1 is containing the text excludes "n".
|
| LOOKUP with Booleans | 15 Sep 2005 07:15 GMT | 3 |
I'm trying to figure out some wierd LOOKUP behavior with booleans. I need to create a lookup function which looks for a TRUE in a range and picks the value from the same row different column. It would look like this:
|
| no number 1 | 15 Sep 2005 04:34 GMT | 1 |
I came across a program for generating Lottery numbers and tried adapting it for the game we play which has 15 games with 6 of 45 numbers per sheet, but unfortunately I can''t find it again in the Excel forum
|
| Looking for function to pick out names and at values from the same row | 15 Sep 2005 03:40 GMT | 1 |
Say I have 3 Rows: Income | Expanses | Memo
| 10.00 | Food | 5.00 | Gas |
| Put daily use worksheets in a toolbar in Excel | 15 Sep 2005 01:47 GMT | 1 |
I have Excel 2003 with all updates. Seems to me I used to have a custom toolbar in the menubar area with shortcuts to files I used every day - but it was a long time ago. Is there a way to do that? Thanks, Marti
|
| Copy Only Visible Cell | 15 Sep 2005 00:26 GMT | 2 |
Is it posible to copy a block of cels with combined hidden collumn and row to another sheet or cells without those hidden field to be copied ? When i try to copy this kind of cells to another sheets/cells, excel copy all cells including the hidden cells.
|
| Date List for Data Entry | 15 Sep 2005 00:23 GMT | 1 |
Is there some way to insert that date box in a cell to pick a date like I can make a list for data entry? Thanks Jerry
|
| Installing Excel to a Flash Memory Pen | 14 Sep 2005 22:24 GMT | 2 |
I am struggling with Excel 97 at work and running with Excel 2003 at home, unfortunately the upgrade process at work takes a little time !! Is there anyway that I could install Excel 2003 or Excel 2002 onto a Flash Memory pen, which I could then stick into my work PC and use ?
|
| Domestic expenses in Excel, please help | 14 Sep 2005 22:02 GMT | 4 |
I am not an excel developer, not even a user. A friend of mine suggested to track my daily expenes with Excel:- a) Category of expense (weekly food shoping, car expense, clothing ...) b) Price
|
| Strange cell behaviour | 14 Sep 2005 22:01 GMT | 3 |
There's a very strange problem i'm currently having when entering figures into any cell in any workbook. For instance, when i enter '1', the figure 0.01 is displayed, 10 = 0.1 and so on.
|
| importing data | 14 Sep 2005 21:28 GMT | 1 |
I am starting up a new business( solo Family Practice physician). I have Windows ME. The excel package comes with a small business financial manager, which says that I must import my database. I am looking for a simple/inexpensive way to balance my business checkbook and ...
|
| using the delimited function | 14 Sep 2005 20:52 GMT | 3 |
I have an example where a date is listed as: 01/17/2005 and would like to be able to display the information into separate columns. so that I can use the sort data function in a desending order. Is this possible and if so, how to do it? thanks
|
| Excel Graph | 14 Sep 2005 20:15 GMT | 2 |
Is there a way to get excel to calculate the slope of a line created by a set of data points entered into the spreadsheet?
|
| Macro help (last row) | 14 Sep 2005 20:12 GMT | 3 |
Hello: I have recorded a macro to do a certain function everyday. The column formatting for the macro is the same everyday but the number of rows that it contains may differ from day to day. I do not know how to do visual basic and have recorded the macro by doing the ...
|
| =Month function in Excel gives incorrect month | 14 Sep 2005 19:59 GMT | 1 |
I have a problem in Excel 2003, the result I get when I enter the =Month function with a date from September (9) gives me a January result. No idea why it's donig it.
|