| Thread | Last Post | Replies |
|
| Excel # of Comlumns Extension | 31 Jan 2004 23:31 GMT | 1 |
Currently the maximum number of comumns of is IV. Is there a way to increase the number of Columns?
|
| How might I do this | 31 Jan 2004 22:56 GMT | 1 |
I have a spreadsheet I use to calculate total hours worked per day, I then record those hours in another column by date so I can track total hours by week and still retain the hours each day. A B
|
| LastCellWithData | 31 Jan 2004 22:26 GMT | 1 |
The function, "LastCellWithData" shows up on my Excel list of functions pulldown menu, though its original source is foreign to me. And, there is no "help" feature available to sort of educate me. Well, on the built-in function box where one fills in the various
|
| Count Functions across multiple worksheets | 31 Jan 2004 22:14 GMT | 5 |
I need some help. I have a spreadsheet that has upto 30 worksheets in them. The data in each worksheet is the response from a person on 60 questions. Therefore for example, the cell B4 has
|
| How to split cells into 2 in Excel 2000 | 31 Jan 2004 21:21 GMT | 5 |
Does anyone know how to split cells into 2 or more cells in Excel 2000
|
| If This - If That | 31 Jan 2004 21:07 GMT | 2 |
Excel 2000 Issue This is what I want to accomplish. I have two workbooks Workbook A
|
| countif function | 31 Jan 2004 20:54 GMT | 1 |
hi, i need to put .5<3.5 in the criteria of the countif function but i don't think you can do that, as the value i get is always 0..whereas if i put <3.5...it returns with the correct value...is there another function i can use that will let me count the no. of times data appears ...
|
| Function not evaluated | 31 Jan 2004 19:37 GMT | 1 |
I created a simple function in a workbook using tools/macro/vb editor. When I assign the function to a cell in the worksheet, instead of being evaluated and returning the value, the function call appears text in the cell. My function is as follows.
|
| protect / unprotect multiple sheets | 31 Jan 2004 18:31 GMT | 4 |
Hi, I'm trying to protect and of course, unprotect multiple sheets at the same time, without using the Tools/Protection/Protect Workbook option - that option is not protecting the way I want. I have many sheets in my file and would like to be able to select a range of them (I do ...
|
| importing access data into excel | 31 Jan 2004 15:53 GMT | 1 |
I?m from Portugal and. I would like you to help me to make a project that import records of specific acess database into a excel sheet. For example:
|
| import pictures into excel | 31 Jan 2004 15:50 GMT | 1 |
I am creating a program in excel in which it is for a tile shop. i hav a product list page which contains pictures of the tiles. i want picture of the tile to appear on the quote sheet. how do i do this --
|
| Concatenate text with a carriage-return | 31 Jan 2004 15:28 GMT | 1 |
I have two cells with the following text; A1 = "abc" B1 = "def" I want to concatenate these two text into C1 with a carriage-return
|
| Probably Easy Answer! | 31 Jan 2004 15:22 GMT | 4 |
When I write my formula in the cell then enter to move out, instead of the answer being displayed I see the formula on the sheet. What am I doing wrong. I've tried everything I can think of! Please help........
|
| Help with countif function | 31 Jan 2004 14:50 GMT | 3 |
I've created a very simple formula using countif. =(COUNTIF('Sheet1'!$D$4:$D$4000,1)) Adjacent to column A where "1" appears I have a another number which I would like to find a total for.
|
| Possible Concantenate | 31 Jan 2004 13:53 GMT | 2 |
Excel 200 Issue I have 2 spreadsheets in the same workbook Spreadsheet A cell F9 value is 50
|