| Thread | Last Post | Replies |
|
| how to open email from opt on line to excel | 02 Jan 2006 17:04 GMT | 3 |
We have optimum on line as our internet server and have purchased the MIcrosoft 2003 Standard office version.. have installed the programs but now have received an email which would require excel program and can't seem to open the spreadsheet .. do we need to collate our ...
|
| Add-in must be 'run' one time to stick? How to auto invoke? | 02 Jan 2006 16:40 GMT | 4 |
Thanks to Dave Peterson's recent sample and tips to get started I have gotten past the notion of a script-holding template file and gotten all the functionality I need into a .xla addin menu The functions in the addin are made available thru a toolbar
|
| how can i make excel from vertical to horizontal? | 02 Jan 2006 16:21 GMT | 2 |
how can i make excel from vertical to horizontal?
|
| Help with Weekly Personel Schedule | 02 Jan 2006 15:54 GMT | 1 |
Hey everyone, I've been using Excel to create the weekly schedule for my department at work (roughly 8-10 people), as well as daily assignment sheets that list the people on, hours working, and an hour-by-hour breakdown of their job
|
| 2 criteria cells used to select which validation list to use | 02 Jan 2006 15:43 GMT | 4 |
Greetings All: (Excel 2003) I'm trying to "clean up" various workbooks and consolidate into one workbook (probably about 75 sheets, when done). I have come to the conclusion that,
|
| Need help on some calculations.. | 02 Jan 2006 14:28 GMT | 6 |
Im not quite new at using Excel, but I have decided to try to take on new challenges and I need some help in relation to that. #1: I want to make some calculations on 4 values, lets say that they are located
|
| Problem with dates | 02 Jan 2006 14:24 GMT | 2 |
I have a date problem. I have got a workbook with a date column from a friend. When I copy a cell from the date colomn and past it in another workbook I get a different date.
|
| showing the contents of dynamic cells | 02 Jan 2006 13:52 GMT | 3 |
If I use the following spread sheet as an example a b c 1 23 2 34 2 22 23 75
|
| Decimal days | 02 Jan 2006 13:34 GMT | 4 |
Hi Newish to Excel, so apologies if this a really stupid post. Doing an annual leave calculator which gives as one its results th decimal figure of, for example, 33.5 days, i.e. thirty three and a hal
|
| =if(and(a2>100,a2<200),....if Only.... | 02 Jan 2006 12:06 GMT | 4 |
Hi, I'm trying to give a cell a value based on the number in another cell with =IF(AND(A2>100,A2<200),"This is between 100 and 200","No it's not between 100 and 200") this works fine, I just don't understand how to nest other OR or AND functions in there as well to give a different
|
| Formula as text | 02 Jan 2006 11:01 GMT | 1 |
Happy new year.. Why C2 cell as the result of VLOOKUP which contains "APPLE" can be rea by D2 as formula which cause D2 becomes "RED" unless in cell C2 type "APPLE"?
|
| Question about Simple task | 02 Jan 2006 03:37 GMT | 1 |
Hey everyone, I'm currently running an ebay involving the buying of lot of video games, and then the selling of invidual games. I would like t have three columns. One would consist of the Title of the game, i alphabetical order, one the quantity of games I would acquire, and th
|
| How do I convert a formula calculated number to a current value ? | 02 Jan 2006 00:44 GMT | 2 |
Trying to use the formula calculated number as a current value-
|
| Excel question with if statements | 01 Jan 2006 23:10 GMT | 2 |
I have a monthly financial projection model and I am trying to build the following functionality. One assumption is that there will be an acquisition in any given month. For this I have set it up so when a person enters the month on the
|
| Excel in Office 12 | 01 Jan 2006 21:10 GMT | 2 |
In Excel 12, if text in cell is very long, and you build a pivot table, it works, BUT if you and save the file in Excel 03 format (*.xls), it destroys the pivot table on opening the new .xls file. Why? Workaround?
|