| Thread | Last Post | Replies |
|
| Optimization project | 26 Apr 2006 15:12 GMT | 2 |
I am a novice to the solver function and would be very appreciative if someone would be able to offer me a solution utilizing solver. I need to find what is the optimal product mix of the following computer items given their respective prices, per unit:
|
| excel time format | 26 Apr 2006 15:03 GMT | 2 |
How can i format a cell that will display the ime as 08:00 when i enter 8? i have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00.
|
| Mailing Labels to Spreadsheet. | 26 Apr 2006 14:29 GMT | 2 |
I have seen this question before but am unable to find the message. I have a MS Word document in address label format. I would like to convert this file to a spread sheet. How do I do this? Thanks
|
| Specified fields | 26 Apr 2006 13:11 GMT | 3 |
Can you predefine options to fill in a cell. For example I only want people to able to choose. 01 - Annual Leave 02 - Sick Leave
|
| Work out overtime hours for individuals | 26 Apr 2006 12:52 GMT | 3 |
I have a question which i am hoping someone will eb able to help me with, i have a spreadsheet which contains infromation for part time hours worked during the course of a month for individuals (e.g. below) Name Start End Hours
|
| Floating Excel window | 26 Apr 2006 12:48 GMT | 3 |
Is it possible to make an excel worksheet, or excel float on my desktop so that it remains always visible. I want to use it as an adbaced calculator that flost on top of other applications.
|
| how do i count text and display it as text plus the # times it hap | 26 Apr 2006 10:15 GMT | 1 |
PromotionName UnitSales ChannelName Quarter Boxing Day 1200 Richard 1 1 Boxing Day 1300 Will 2 2 Boxing Day 1600 Will 3 3
|
| Setting a default sort for a range | 26 Apr 2006 09:32 GMT | 2 |
How do I set a default data sort on a selected range in Exel. I select from the collumn that the data need to be sorted on. But I have to select decending all the time and select no header row all the time. All I want to do is select the range to sort and hit OK.
|
| formula help please | 26 Apr 2006 09:21 GMT | 2 |
Alright I hope I can explain this good enough I tend to ramble... I have created an "accounting workbook" for my father in law to do his books in. He is a farmer, he is late 50's and has only had access or ever used a computer for the first time last month. He finally bought
|
| Across Worksheets Again | 26 Apr 2006 09:09 GMT | 2 |
How would I make my name appear in cell D9 on every worksheet in th workbook with out manually inputting my name into every workshee (there are 240!) --
|
| Subtotal Grades | 26 Apr 2006 07:58 GMT | 3 |
I have a list of names with grades blah blah, and have calculated their number grade. ALso, I used Vlookup and a lookup table to calculate their letter grade. NOW:
|
| Applying more than 3 conditional formats | 26 Apr 2006 06:47 GMT | 3 |
I would like to apply a different cell colours to a range based on the cell value compared with a fixed scale of values. e.g. values between 0-10 get "green" cell background
|
| Format colorful for a cell (that has formula) | 26 Apr 2006 03:07 GMT | 6 |
Formating colorful for a cell that has formula is posible? For example: = "I'm " & 1 + 1 & "years old" And the desired result is: "I'm 2 years old" So, these is any way for me to do this. Please help. Thanks so much.
|
| vlookup | 26 Apr 2006 01:55 GMT | 4 |
How can I make this work? I have a worksheet. I need to extract the first two digits of a number. The two digit number determines which equipment to use.That number checks against a vlookup table and then the equipment is entered in another cell.
|
| Pivot Talbe Help | 26 Apr 2006 00:09 GMT | 3 |
I've got three columns. A2:A7000 is customer number. B2:B7000 is a circuit ID (unique telecom ID). C2:C7000 is revenue
|