| Thread | Last Post | Replies |
|
| max of average | 28 Nov 2006 21:58 GMT | 5 |
how would you take the max of an average in a situation such as this: 1 2 3 3 4 2 2 3 4
|
| Cell address | 28 Nov 2006 21:46 GMT | 6 |
Hi all, I am trying to find a cell adress in a table sized 7 * 53, i am totally stumped please help before my brain explodes
|
| Password Access to certain sheets | 28 Nov 2006 21:39 GMT | 2 |
I have a workbook with several sheets. I use this for several offices and I want to set it up so that the user can only view the sheet that pertains to them.
|
| Adding hours to a date | 28 Nov 2006 20:50 GMT | 6 |
I want to add a number of hours to a date and a time and have Excel give me the resulting date and time. The hours that I will want to add to the date could be anything, including part days, eg 3.25 hours, 92.4 hours, and so on.
|
| VLookup returning more than one Row of information | 28 Nov 2006 20:09 GMT | 1 |
I know this has to be easy but for the life of me I can't figure it out. I have a Vlookup statement...IF(ISNA(VLOOKUP($A2,COREDB,8,False))," ",VLOOKUP($A2,COREDB,8,false))...it works but it only returns information from one entry. The number in cell A2 appears in the database ...
|
| Exporting Time Formatted Numbers inside Macros | 28 Nov 2006 19:56 GMT | 4 |
I have a Macro that exports certain pieces of data into a ".TXT" file. Everything is working well, but today, I am trying to add to columns to the export file, both of which are stored as Custom "h:mm" time values. Currently, for example, the following values are in the ...
|
| SaveAs | 28 Nov 2006 19:51 GMT | 5 |
this might be an easy one for someone in here , i have a short script that saves a file in 2 places by over writing the exsisting files, when i run the script i get a box that requires me to click on it to overwright the file.... how can i get the script to do this without asking ...
|
| Find Variance | 28 Nov 2006 19:30 GMT | 2 |
Ok.. don't know if the terminology is correct, but basically what I need to do is... I have found all of the manufacturer's products where they have charged us different unit prices. I will need to prioritize them so that we work on the items with the most significant difference ...
|
| duplicating worsheets | 28 Nov 2006 19:11 GMT | 2 |
I have created a template that I would like to duplicate to other worksheets in the same workbook. When I copy and paste the font size and column widths do not stay the same. How do I fix?
|
| VLOOKUP puzzle ?? | 28 Nov 2006 18:54 GMT | 7 |
getting a little frustrated with what I though would be a simple VLOOKUP formula, so turn to you for help. Cells C6:G80 are populated with data I want the whole of column G to be searched for the exact code FQR and when
|
| when doing a grade book how do you drop the lowest grade | 28 Nov 2006 18:54 GMT | 2 |
I am trying to do a grade worksheet. I am looking for the formula for dropping the lowest grade
|
| How can I use autosave from excel2000 in excel2003 | 28 Nov 2006 18:50 GMT | 14 |
I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time
|
| Finance functions discrepancy | 28 Nov 2006 18:24 GMT | 4 |
Note: I have previously posted this in NG microsoft.public.excel.worksheetfunctions (note the lack of a 'dot' before functions). I've had no response, and it looks like a very queit NG, so have posted here. Hopefully someone can help . . . .
|
| Spreadsheets--Adding Quantities | 28 Nov 2006 18:15 GMT | 4 |
If I have two different worksheets, lets say spare mechanical parts, that list the part number in 1 column and the quantity in stock in another column. Is there a way to bring them together so that the quantities of any duplicate part numbers will add up? For instance if on 1 ...
|
| Subtotaling of hours | 28 Nov 2006 18:03 GMT | 2 |
Example: A B C TIMESHEET In out Hours
|