| Thread | Last Post | Replies |
|
| how to remove gridlines from part of a worksheet only | 27 Mar 2008 20:21 GMT | 12 |
probably simple but I'm a novice. building a worksheet to list people, pay rates and hours worked etc. the header needs to have fill in areas that change with the job so I entered them in the rows rather than in a proper header. what I want to do is get rid of gridlines in the ...
|
| Best way to subtotal this data? | 27 Mar 2008 19:39 GMT | 8 |
Hello all, I have a worksheet with a bunch of data that I need to extract certain statistics from. I need to show the total number of hours charged by each person to each group they worked in for the last year. So, I need to sort by
|
| Second Saturday Of The Month | 27 Mar 2008 19:20 GMT | 7 |
OK, this may seem fairly simple but I'm missing something ... Is there a formula that will calculate the Second Calendar Saturday of the Month for me?
|
| rotate columns | 27 Mar 2008 18:46 GMT | 2 |
I'm needing to keep a running total of the last 7 days of hours worked for several employees. I have it set each time excel opens the first time each day the date will change to the new dates. however I need the columns with the hours from the corresponding days to rotate with ...
|
| V Lookup and Paste Special | 27 Mar 2008 18:29 GMT | 6 |
I'm doing a VLookup function in Worksheet A to find in Worksheet B. The data in Worksheet B was paste special: values. I did subtotals on the original data and wanted to see the subtotals without the detail this is why I pasted special as values. .
|
| I forgot my password | 27 Mar 2008 18:29 GMT | 1 |
The password I thought I typed into my workbook does not work. How do I get into my workbook?
|
| Remove useless information | 27 Mar 2008 18:16 GMT | 2 |
How can add all the numbers for a total, and only Keep in all in one line. Example below, nubers totals 9, but i only need that with one name, one address, one city, one state, and one phone #...I have a spreadsheet that have been working on for two days.
|
| track changes | 27 Mar 2008 17:36 GMT | 1 |
can i set up track changes on a destination workbook? it is linked to 14 different spreadsheets.
|
| Fill color wont' stay | 27 Mar 2008 17:21 GMT | 1 |
Ok, I set row 1 with a RED fill, but every time I save the workbook, it reverts back to "No Fill". The text, however, stays white. Any idea's why this is?
|
| Annual leave monthly calculation | 27 Mar 2008 16:45 GMT | 2 |
I have made an exel sheet to calculate the vacation leave for all the employees and i have used this formula C7=starting date
|
| Double Vertical Index & Match | 27 Mar 2008 16:28 GMT | 7 |
Sheet1 A B C 1 Date Time Score 2 3/1/08 0000 91
|
| stock inventory | 27 Mar 2008 16:11 GMT | 1 |
I'm trying to create an inventory worksheet(maybe very simple to some of you) where it has only two columns A(part #) and B(number of part available in stock). Please help if there is anyway I can just enter part number in columnA then columnB will automatically adds up quanity ...
|
| MAX Value | 27 Mar 2008 16:07 GMT | 7 |
Trying to create a MTBF database... The File will contain in Column "A" Internal part number (can be used more then once) and in Column "B" external part number (Should only be used once, but, may be used more then once)... I am entering MTBF data in column "C" and would to
|
| Count all rows in column with data, Except rows 1-5 | 27 Mar 2008 15:58 GMT | 4 |
I would like to count all of the rows in Column A that contain any text, except Rows 1 through 5. I have the following formula, which worked, but included rows 1-5. =COUNTIF(Clients!A:A,"*")
|
| Sick Time Reports | 27 Mar 2008 15:31 GMT | 1 |
I am trying to come up with a sick time report (very simple) that adds 4.0 hours of sicktime on the 1st and 15th of every month - and will allow me to plug in time off and have it deducted. Does anyone have this already?
|