| Thread | Last Post | Replies |
|
| How do i repeat dates monthly over the year | 20 Nov 2006 18:23 GMT | 2 |
1 Feb Youth Leaders Meeting 9 Feb Specific Meeting TBA Serving & Leading Seminar 23 Feb Social or Youth Activity
|
| Working with data from two worksheets | 20 Nov 2006 17:42 GMT | 1 |
Can some one help me, please? I am working with two worksheets - one a Summary Page which is a Pivot Table and the other the data page which contains the information for the pivot table.
|
| count articles of a column that the result is between an intervall | 20 Nov 2006 16:03 GMT | 3 |
I need to count the diferent articles of a column where the result its between an interval (the criteria is defined in two cells). in my datasheet its possible that the same article has different results. example:
|
| When in filter mode status bar doesn't show range of cells filted | 20 Nov 2006 15:18 GMT | 1 |
I am working with a large excel sheet of data but when I wish to know the range of data within this for instance when I filter out specific data, it doesn't show me on the status bar how many cells have been selected, it simply states FILTER MODE. I need the status bar to tell ...
|
| How to display >123 by ">" + if(true,1+1,2+2)? | 20 Nov 2006 14:18 GMT | 2 |
Does anyone know how to code following into >123 by ">" + if(true,1+1,2+2)? which display a string plus an integer into a cell. Thank you for any suggestion Eric
|
| Code to Unhide Rows using Macro | 20 Nov 2006 14:08 GMT | 6 |
I’m using Excel 2003, what I intended to accomplish to create a macro to unhide row (By default few rows will be hidden) based on the drop down list value of a Cell. Say I have created a dropdown list in F2 cell using Data>Validation>List
|
| formulas will not compute | 20 Nov 2006 14:02 GMT | 1 |
I have a worksheet with some simple formulas, 1 for aging and another to compute a cell * a fixed number. one is today()-H1, the other is G4*78. The formula works fine for existing data that is in the spreadsheet. Now for some reason, when i open the spreadsheet and enter in a ...
|
| Wildcard in Excel | 20 Nov 2006 13:27 GMT | 4 |
hi, I am trying to search for 10070162*** as a whole string text, the asterisks do not represent wildcard characters. When I use 10070162*** as the lookup value in vlookup, it brought back results for 10070162001, 10070162002 etc. Is there a way to disable Excel from treating ...
|
| Is there a way to prevent pasting data into an Excel worksheet? | 20 Nov 2006 13:01 GMT | 16 |
I work in a correctional centre. Some of the correctional officers have little training to use Excel or other programs, but are required to complete spreadsheets on line. Although we have heavily protected the worksheets and locked cells, we find that in some cases the staff ...
|
| Flashing cell | 20 Nov 2006 12:47 GMT | 1 |
If Cell a1 > 50 Then Cell a1 must flasher a different colour
|
| How do I combine text and a calculation in the same field? | 20 Nov 2006 11:37 GMT | 5 |
I am trying to do a calculation and have text follow that in the same field. An example might be as follows : =(H30/4) per week I want the calculation to be there, be a space and then the words "per week" in the same field. I do not have room for another column just for those ...
|
| Sorting a Column and taking row information with it. | 20 Nov 2006 10:54 GMT | 2 |
Please help. In Column "A", I have number 4567 with information pertaining to 4567 in row A5. When I try to sort Column "A" by numbers the information does not move with
|
| Text=Number | 20 Nov 2006 10:17 GMT | 6 |
I have an Time and Material Calculator that I have made. I would like to be able to asign a number to a letter. Example if I enter "C" into a column I would like it to represent .001. If I enter "M" into the same column I would like it to represent .0001, and if I enter "E" it ...
|
| how do i insert rows in a cell | 20 Nov 2006 10:15 GMT | 1 |
I have a s/sheet which has a large cell and i need 5 rows within this cell..but not the adjoining cells. There must be a way of just inserting rows into a cell? Thanks
|
| random number | 20 Nov 2006 09:05 GMT | 1 |
Can somebody tell me how to do this in Excel I wish to create random number between 1 to 64 with reset value 0, when a submit button is pressed a random single number is generated between 1 to 64 and when reset button is pressed it goes back to 0 or
|