| Thread | Last Post | Replies |
|
| convert column values | 15 Jun 2006 19:13 GMT | 5 |
I'm sorry if this is already here somewhere, but I could't find any references. I need to upload a list of people into our computer system and this list is comprised of their names and the code for the branch where they work. The computer system into which I need to upload this ...
|
| how do I lock values in excel | 15 Jun 2006 18:55 GMT | 1 |
I am working on a spreadsheet where the values on one sheet in a workbook are appear on a second sheet in the same workbook using the following formula: =('Employee List'!A171) The input sheet is called Employee List. I would like to "lock" the values
|
| Help... in excel. | 15 Jun 2006 18:54 GMT | 1 |
I'm working from a download excel file that I copy and paste to an existing work book. I have a sumif formula that i'm using to pull information from the download but am running into a problem with the "cr" (for credit) in my download. I need for it to show "-" or "( )" . Is ...
|
| Formula for computing day of the week and time | 15 Jun 2006 18:45 GMT | 4 |
I have a cell containing information in the following format: Mon 6/12/2006 2:56 PM I would like to break this into 3 individual cells for day (spelled out IE Monday) date and time.
|
| Simple SUMIF, I think... | 15 Jun 2006 18:33 GMT | 7 |
I have 2 columns of data. In col B I have a % value; in col C I have various project names. I need a formula that will show me the total of col B for each project name in col C. There is no data after col C so I could use those cols for the results.
|
| calculating adjacent columns in a work schedule | 15 Jun 2006 18:30 GMT | 3 |
I am working on a schedule where there are many different workers, and many different shifts of different lengths are being used. I have been trying to create a formula that sums the total hours for each person, based on the name in the adjacent column. For example:
|
| Excel worksheet functions question. | 15 Jun 2006 18:23 GMT | 3 |
Basically I am new to excel but I am trying to have it where when someone inputs a certain number from a list of numbers that it will put in the proper "x's" in the column on the sheet. I have put the list of numbers and the X's that belong to those numbers in columns on sheet 2 ...
|
| HELP WITH A FORMULA | 15 Jun 2006 18:23 GMT | 4 |
I need help figuring out a Formula, in my Excel Sheet i have Total COST in Cell E65534 and in F65534 I have Cost that I charged My Customer. I need a Formula that will calculate the Margin that I had earned for that transaction. So that i can figure out what my margins are, ...
|
| averaging times | 15 Jun 2006 18:23 GMT | 4 |
I have a problem with averaging times. This is what I have e12 – i12 are input as the time taken to achieve a task. This could be anything from 0.01 (min.secs) up to 9.59. These times are then averaged to
|
| locked cells with 2 different passwords? | 15 Jun 2006 18:22 GMT | 2 |
Trying to setup a timesheet where the user can paste a jpg of their signature and then password protect it. THen forward it to the supervisor who would do the same. Anyone know of a way to do this? Thanks!
|
| Creating a formula using RAND | 15 Jun 2006 17:53 GMT | 2 |
I have a spreadsheet that has a group of peoples names on it. I want to be able to create a formula that will cause it to randomly choose one of those people on the list. I know there is a way to create a formula for this but I completely clueless on how I would type the formula in.
|
| Need help with averaging a time but dates are messing up the result I am trying for. | 15 Jun 2006 17:48 GMT | 4 |
I am attempting to get a worksheet that averages times but I am running into a few problems. For example I have this setup.... A1 = 05/11/06 11:00 PM B1 = 05/13/06 11:30 PM
|
| indirect function within sumif to reference other sheets | 15 Jun 2006 17:46 GMT | 3 |
I have a workbook with many sheets, most of them being financial information, ie last year actual / budget, this year actual/budget etc. I then have a sheet which I am making a report on to summarise all of the other information. Each line is a sumif of all the relevant cost /
|
| Assistance with Formula | 15 Jun 2006 17:11 GMT | 3 |
I have a workbook which I produce my Sales Quotes in. Basically, on one page, I feed in all the relevant information and then through various formulas (eg. =B29) where it looks to see what's in the cell where I've fed in the info, it produces the quote on a standard template,
|
| How do I set up a formula to throw out the 2 lowest scores? | 15 Jun 2006 17:08 GMT | 1 |
I would like to enter 8 quiz grades throw out the two lowest scores and get the average of the 6 remaining scores. I know there's got to be a way to do this, I just haven't figured it out yet. Any help would be appreciated
|