| Thread | Last Post | Replies |
|
| What is the quickest method to insert & name multiple worksheets . | 20 Sep 2005 22:55 GMT | 8 |
Need to create several spreadsheets ... each containing multiple worksheets ... Example: Monthly spreadsheets containing a separate worksheet for each day of that month ... Jan-1; Jan-2; Jan-3, etc.
|
| Looking for formula for lowest costs, excluding zero | 20 Sep 2005 22:42 GMT | 7 |
I found a formula for determining the lowest costs from several columns, but I cannot get it to work in my worksheet. This is nearly 1000 lines long. I want to search 4 columns and get the lowest cost excluding 0. Any suggestions would be greatly appreciated. Thanks!!
|
| updating source cells | 20 Sep 2005 22:35 GMT | 3 |
I have a spreadsheet where the user selects a product from a dropdown list. this list is connected to a vlookup that produces a cost (in another cell) based on the product chosen. I want the user to be able to update the price list by simply entering a new
|
| Positives and Negatives | 20 Sep 2005 22:28 GMT | 2 |
I need a formula what will tun a positive number in to a negiive. =SUM($H$5:H6)+(B4) B4 is a negitive number and so my anser apears negitive, but I would like it to apear possitive by adding to the formula not my chainfg any of my numbers
|
| How to report value of zero if calculation goes negative | 20 Sep 2005 22:14 GMT | 2 |
I am doing a simple payroll spreadsheet. Hours Paid and holiday pay weeks are entered. The holiday pay is calculated on an average of 12 weeks. On some occasions if an employee leaves, holiday pay taken over the accrued amount has to be paid back by the employee.
|
| compare values | 20 Sep 2005 22:10 GMT | 3 |
I would like to compare 3 nonajacent values, bold the lowest value and then take the lowest value and multiply it by a selected rate of currency.
|
| Finding number of values in a range on a per year basis | 20 Sep 2005 21:49 GMT | 2 |
I have a column of data that represents task durations. I have a separate column that indicates the year in which the task was completed. I want to get a count of the number of tasks with a duration of 0-30 days, 31-60 days, 61-90 days etc. for each year represented on the ...
|
| formulae have stoped working on an excel sheet | 20 Sep 2005 21:39 GMT | 1 |
a spreadsheet i have been using for the past 6 months has just stopped working the formulae dont work unless u re-enter them again every time
|
| Increasing distance labels using drag down method | 20 Sep 2005 21:25 GMT | 2 |
Here is what I have to deal with. I have around 1,200 labels that I don't want to have to type in. I would like to us the fill down method. The labels will be as follows...
|
| Excel Spreadsheet - Formatting Dropdown lists | 20 Sep 2005 21:10 GMT | 1 |
I have set-up a drop down list on a separate worksheet which contains items formatted in different fonts (red, blue, green, etc). When I reference the the drop-down list the items are in black font only. How do I retain the different fonts in the list? Any help would be
|
| The number of hours in a day cannot exceed 24... | 20 Sep 2005 21:09 GMT | 2 |
I have a spreadsheet that is used to manage time sheets and invoices. The weekly time sheets are on separate tabs and the invoice is at the beginning. The invoice tab uses no special cell content type but Excel seems to thing all of the cells on that tab are formatted to "Time" and
|
| solver problem | 20 Sep 2005 21:08 GMT | 1 |
I am trying to use Solver to optimise a plan. I can set it all up with contraints and it says it has found a solution. The trouble is that this is always whatever the starting point is set at. I know that this isn't optimal.
|
| HOW DO I SET UP A CHART WITH FAMILY IMPORTANT ADDRESSES, NUMBERS, | 20 Sep 2005 21:07 GMT | 1 |
I want a database or template so i can store all the important numbers (ie insurance, home insurance, med insurance,) and the phone numbers that go with them
|
| How do I get all numbers or cells on entire sheet (/1000)? | 20 Sep 2005 21:06 GMT | 3 |
I want to present a financial report in thousands of dollars. How can I make all the numbers on my sheet appear as if they had been divided by 1000 without entering my value and a formula in each cell?
|
| how do i filter multiple columns | 20 Sep 2005 21:00 GMT | 1 |
I am trying to filter morethan one colums. I have 4 columns with differents numbers. I need to pull out all of the number ones and coresponde to a part number. my spead sheet kind of looks like this. 1 13 32 52 51623
|