| Thread | Last Post | Replies |
|
| If statement based on currency format | 19 Sep 2006 15:40 GMT | 4 |
I have a spreadsheet that has a column (column B) of numbers. Some of the numbers are formatted in Euro currency and some are formatted in USD currency. I would like to put a formula in column C to automatically calculate the currency conversion of the Euro to USD.
|
| Excel adds significant digits, resulting in errors in calculations | 19 Sep 2006 15:27 GMT | 6 |
I have data from an 8th grade science lab - before and after measurements of mass. We are plotting a histogram of the differences in mass for a set of data. However, when I plot the histogram, the results do not match the data, which is significant to 2 decimal places. Excel ...
|
| Offset Question | 19 Sep 2006 14:49 GMT | 1 |
I have the following OFFSET formula in a named range =OFFSET('Summary Data'!$D$2,0,0,LASTROW-30) I want to modify it as follows 'Summary Data'!$D$2 ->
|
| How do I calculate exact difference between two dates in y,m,d. | 19 Sep 2006 13:42 GMT | 3 |
I want to calculate the difference between two dates exactly in years, months and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5 years, 0 months and 14 days including both the starting and ending dates. But excel does not give the exact answer. Pl help ...
|
| Naming Sheets using a range in another worksheet | 19 Sep 2006 13:02 GMT | 3 |
Is there any way I can put names in a range on one sheet and then automatically rename sheets with the names listed in the range without manually renaming each sheet
|
| COUNTIF for numbers of dates in column which are 30 days older than today | 19 Sep 2006 12:58 GMT | 3 |
I have a column with dates. I need a count of how many of these date are older than today's date. I tried: =COUNTIF(L7:L155,"-(=TODAY())>30") and it returns 0
|
| formula that writes to a *different* cell? | 19 Sep 2006 12:55 GMT | 2 |
I have 2 columns, a and b, as follows - a1 0 a2 1 a3 text
|
| wildcard characters, can they be used in tables to be searched? | 19 Sep 2006 11:41 GMT | 2 |
I have several tables of data that I am returning into a long ten digit number using V-lookup. The data typed in can vary, and thus so does the resultant 10 digit number. I would like to return specific comments in another vlookup equation based on that ten digit number.
|
| Soccer betting excel | 19 Sep 2006 11:23 GMT | 1 |
Would appreciate a great help ... I am entrusted to make the excel sheet for the Bundesliga here for the only reason i come from India and i am supposed to know Programming. Well jokes apart ... the excel contains the dates of the game, who all
|
| Help with Duplicates | 19 Sep 2006 09:16 GMT | 3 |
I need to use duplicates for good! I have two sheets and I need to figure out two formulas. Both Sheets have similar information. Column A has UPC codes and Column B has a numeric value. I want the first formula to compare every UPC in Sheet 1 to every UPC in sheet 2 and if it ...
|
| Loan Compound Interest Function | 19 Sep 2006 09:01 GMT | 2 |
I'm trying to create a function to allow me to calculate total interest paid on a loan. * The interest is calculated daily (using "annual rate/365" to calculate daily rate)
|
| Charity Auction Worksheet. - Copy a row of data - THANKS | 19 Sep 2006 08:43 GMT | 1 |
I am providing some volunteer work to help a group of ladies that raise money for children and community at Christmas time. Last year I observed that mass confusion when trying to correlate Auction Bidders/Auction Items/Winning Bidders after the Auction.
|
| how do I get excel to use tab to move in a sheet | 19 Sep 2006 07:26 GMT | 1 |
In my sheets I have several areas that needs filled in by our dispatchers, these areas contain info such as "fuel on board" "fuel used" "lock delay" and serveral other areas (approx. 45 different cells are filled in out of a grouping of 80 (5 across x 16 down)). My sheet has ...
|
| Automatically fill info from another spreadsheet? | 19 Sep 2006 06:53 GMT | 2 |
I have two seperate spreadsheets, one inventory (A) and one for customer orders (B). Is it possible to enter the name of product in spreadsheet (B) and have the next cell automatically fill in product number from spreadsheet (A)?
|
| Attachment files | 19 Sep 2006 05:32 GMT | 2 |
I received an Excel file from someone and I found there were a few Acrobat icons attached at the bottom of a worksheet. It is somewhat like attachments in Lotus Note mails. When I clicked the icons, they opened pdf. files in my Acrobat Reader program. I find it is useful in my ...
|