| Thread | Last Post | Replies |
|
| Excel IF formula | 08 May 2005 18:15 GMT | 7 |
To whom it may concern What it is the formula required in Microsoft excel that will return a value of true in cell K1 if the values in cells G1, H1 and I1 are all BLANK?
|
| Eliminating a Column from Formula | 08 May 2005 17:44 GMT | 6 |
Is there a way to eliminate a specific column or columns from any formula ie: sum, average, count etc. when the formula includes all columns In other words if the formula is =sum(A1:H1) I would like to eliminate
|
| Purchase Order/Invoice ledger | 08 May 2005 16:48 GMT | 1 |
What I would like to do is to keep track of everything that we purchase over 12 months. I have already partly designed the worksheet with 5 fields, the last two being Purchase Order cost and Invoice cost. I have totalled both columns.
|
| Time card 24 hour Please help if you can | 08 May 2005 15:28 GMT | 1 |
I have modified the time card template that comes we Excel 2002 its the standard template in the spreadsheet solutions under time card. I have it exactly the way I want it to work but all of the fields that you put times in will not let me go over 24 because its looking for a
|
| problem with the command - method "UpdateFromFile" | 08 May 2005 14:45 GMT | 1 |
Dear Friends! I already asked for help with the method "UpdateFromFile". The aswer from a member of our group was: "help is OK". I am sorry, but I need a piece of code, containing the command. I am not shure what must precede the
|
| average function in Excel 2002 | 08 May 2005 13:50 GMT | 13 |
I wish to obtain the average of a number of numeric cells but wish this average to be ongoing rather than restricted to a range of cells. For example =AVERAGE(D13:D17) will only give the average of the cells D13 to D17 but I
|
| about Password | 08 May 2005 10:44 GMT | 3 |
Hello~~ ^^ I wrote out a document and stored it. And I locked the document with personal code number(password).
|
| HOW CAN I SHOW OUTPUT IN FEET INCH FORMAT | 08 May 2005 06:01 GMT | 2 |
I’m trying to make a calc sheet that shows my measurements in feet and inc format ( 5' 3-1/2") or something similar. thank you for your hlep
|
| limking workbooks | 08 May 2005 05:50 GMT | 1 |
I have 4 workbooks in seperate folders that I need to combine into one monthly summary. The workbooks are different but each contain a columns named, B/L,Amount,Billed. These are the 3 columns I want merged into one spreadsheet. What would be the best way to do this?
|
| MICROSOFT EXCELL (XLS) | 08 May 2005 04:04 GMT | 1 |
i need this to access pictures of female friend overseas, please help. its a spreadsheet file, XLS. THANKS!
|
| xls to dBaseIII issue | 08 May 2005 00:40 GMT | 1 |
I have to convert an excel file to dBaseIII for a mail list program. When I choose save as dBaseIII it saves ok but I have two problems. main problem is I have one column with a 2 character width with numbers. I have to be able to format the numbers as....12 , 34, 06, 09...etc. ...
|
| Superformula required for looking up Duplicates in a range | 07 May 2005 22:05 GMT | 11 |
I've been trying to construct a Duplicate entries/Lookup superformula all to no avail. Column A is a helper range (optional). Column D contains strings of numbers and/or characters.
|
| Average Row Formula | 07 May 2005 19:16 GMT | 5 |
Is there a way to calculate the average of a row if some cells are empty but when calculating the average they should have the value of the cell to the left? If the following data is enterered
|
| Excel: Latest Version? | 07 May 2005 19:11 GMT | 6 |
I'd like to surf Australia's Ebay for the latest Version, I aim to export data from a large Visual FoxPro Database. What do I look for, and do I need any add-ins etc. Thank you for any advice.
|
| External query where parameter is a sheet cell | 07 May 2005 17:53 GMT | 1 |
I want to run an SQL to an external database source where the parameter of the query is specified in a sheet cell. For example: select amount from mynumbers
|