| Thread | Last Post | Replies |
|
| Sum and Offset: to add from a point to the last entry in the colum | 16 Mar 2007 18:14 GMT | 5 |
I am using Excel 2003, I want to put a formula on my spreadsheet in O9 that will sum from O13 through to the last value in the column which changes all the time. I have tried using sum and offset but I just can't seem to get it to work.
|
| How can I separate a large spreadsheet into worksheets? | 16 Mar 2007 18:09 GMT | 5 |
I have a large .CSV spreadsheet that shows all of sales history for the past 12 months. I would like to separate that data into bottom-tabbed worksheets. I will end up with about 100 worksheets. Our 10-digit customer code is the first column in the spreadsheet.
|
| Formula needed | 16 Mar 2007 18:08 GMT | 2 |
I want create a formula that if the Min column (C3, F3, I3, and so on...) is greater than 0, then A1 will combine the XX1, XX2, XX3 and so on... can anyone help???? For clarification... then A1 will combine to show "XX1, XX2, XX3" and so
|
| change value across cells | 16 Mar 2007 17:48 GMT | 7 |
Cells E16 through P16 contain different numbers. I would like to be able to select all cells in this range and apply a 3% increase. Is there a function that will handle this? Also, if several of the cells contain a formula, is there a way that I can
|
| How to add either radio buttons or checkboxes to an excel sheet? | 16 Mar 2007 17:31 GMT | 1 |
I have a checklist people use to complete a list of tasks from an excel spreadsheet, and i just have brackets like [ ] on the excel sheet. They print it out and check things off with a pencil and keep hard copies. I'd like to make it so that I can have checkboxes there instead, ...
|
| DropDown Question | 16 Mar 2007 17:09 GMT | 3 |
In excel is I possible to control what is available in a drop down based on the value of another cell? Example If I select EUR in Cell A1 I want the selections available in cell b2 to be
|
| IF Statement | 16 Mar 2007 17:05 GMT | 7 |
In my Excel spreadsheet I am trying to figure out a formula to combine an examiner's initials with a specific date in which a record was audited. For Example, part of my spreadsheet looks something like this: Date
|
| date calcualtion | 16 Mar 2007 16:59 GMT | 5 |
I am trying to return a date that is seven days prior to the date I choose, but I want to omit Saturday and Sunday. Therefore if the date of the event is Sunday March 18, 2007 and I want to receive payment seven days prior I would like to have the formula automatically return a ...
|
| Find the nearest Christmas to a date | 16 Mar 2007 16:48 GMT | 1 |
I am setting up a class schedule that needs to account for time off during Christmas. The classes all take the same number of work days, but some have a 2 week vacation in the middle for the Christmas holiday. Since I am building a class schedule for several years in advance, I ...
|
| Vlookup based on valid match of mutiple columns | 16 Mar 2007 16:48 GMT | 8 |
Is there a way to do a vlookup based on a valid match of 2 values on seperate columns? Example Data..... 3/12/07 3110 23.23
|
| NCAA tournament brackets template from Template gallery. | 16 Mar 2007 15:33 GMT | 2 |
How does the template update with the winners. Do you have to turn on something to get the template to show the winners.
|
| isna vlookup #n/a but not false | 16 Mar 2007 15:30 GMT | 1 |
I am creating 1 spreadsheet from 2 moving sheets using Vlookups. However not all sheets have the same things to look up and returns #n/a - I can change to use isna, but if I use for all cells I get False where their would be a value without the isna.
|
| Modifying data in excel containing 4000+ formulas | 16 Mar 2007 14:14 GMT | 2 |
I have an excel that has more than 4000 formulas and now i cannot modify data in it. It keeps hanging each time I try to update it. Does anyone know how this can be dealt with? Thanks!
|
| كيف يمكنني ان اجعل البيان ات المدخلة لا تتكرر؟ | 16 Mar 2007 13:24 GMT | 1 |
كيف يمكنني ان اجعل البيانات المدخلة في برنامج excel لا تتكرر؟
|
| Replace #VALUE! with contents of cell?? | 16 Mar 2007 11:33 GMT | 1 |
Hope someone can help with this! I am exporting content into excel, where alot of the data contains '='. Excel is then using the formula on this data and so '#VALUE!' is appearing in every cell.
|