Threads Replies Last Post 837 Pages: <<  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  >>   How do I calculate exact difference between two dates in y,m,d. 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 me.... 4 19.09.2006 12:42:46 Naming Sheets using a range in another worksheet 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 -- gazza... 4 19.09.2006 12:02:58 COUNTIF for numbers of dates in column which are 30 days older than today 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 Anyone able to help here, please? Thanks Jonathan ... 4 19.09.2006 11:58:11 formula that writes to a *different* cell? I have 2 columns, a and b, as follows - a1 0 a2 1 a3 text a4 10 a5 more text a6 4 a7 3 a8 23 a9 1 a10 3 b1 b2 b3 b4 12 b5 b6 b7 b8 25 b9 b10 What I want to do is replace the contents of A with the contents of B if it exists, otherwise leave it as-i... 3 19.09.2006 11:55:32 wildcard characters, can they be used in tables to be searched? Hello! 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. The comments however, do not depend on all ten digits, only a few. So I made another table in Excel that i... 3 19.09.2006 10:41:53 Soccer betting excel Hi Guys, 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 betted for the game, and how did he / she bet at the end of the game day. Finally it would be something like an average as to who bet th... 2 19.09.2006 10:23:10 Soccer betting excel Hi Guys, 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 betted for the game, and how did he / she bet at the end of the game day. Finally it would be something like an average as to who bet th... 1 19.09.2006 09:58:59 Help with Duplicates 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 finds duplicates to give me the difference between the numeric values. I want the second formula (or formulas) to... 4 19.09.2006 08:16:01 Loan Compound Interest Function 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) * Accrued interest is applied to the loan monthly on the last day of the calender month. * Payments will be regular, either fortnightly or monthly. This will be a generic function, but needs to be accurate as it m... 3 19.09.2006 08:01:22 Charity Auction Worksheet. - Copy a row of data - THANKS 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. I believe the solution is simple. – I just need assistance with a formula that will look up a value (WINNERS field) on the winner... 2 19.09.2006 07:43:01 how do I get excel to use tab to move in a sheet 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 these areas in a side by side groupings ( A1-E1 BY A16-E16 grouping of 80 cells and G1-K1 BY G16 BY K16 grouping o... 2 19.09.2006 06:26:03 Automatically fill info from another spreadsheet? 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)?... 3 19.09.2006 05:53:01 Attachment files Dear all, 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 daily works. Please advise how to make attachments inside Excel files? I prefer the attachments are ... 3 19.09.2006 04:32:02 Avoiding Recalculation for a function in automatic mode I got 2 functions in my Excel func1 and func2 and its running in automatic mode. Since my excel i s running in automatic mode, both functions are called again and recalculated. I would like to avoid recalculating of func1 but would like func2 to recalculate again. Is there a way for this?? Since when I set EnableCalculation = True , both functions are called.... 2 19.09.2006 03:52:01 indirect formula help i need to use a formula in which the variable part is the worksheet name, i'm trying to use INDIRECT($A$1 & "!A2"), where the value of $A$1 is the worksheet name, but when i copy my formula to the other cells, the A2 part does not update how do i make it automatically update to the current cell reference?... 11 19.09.2006 03:44:01 Highlighting and tracking changes The company I work for uses Excel to record meeting minutes, and this then forms the basis of subsequent meeting minutes. Changes made during each meeting are manually highlighted by means of a formatting change, such as a colour change to indicate an added note. This means before each meeting, the old minute has the colour changed to standard, and as we enter new comments/notes, we have... 2 19.09.2006 03:26:02 goal seek minimize function I would like to optimize shipment sizes by taking both shipment and storage costs into account. I would like to use the goal seek function to minimize the value in a certain cell (total cost) by changing another the value in another cell (shipment size). However, I have found that the goal seek function is set up in such a way so that the value in the goal seek cell is set to a certa... 3 19.09.2006 03:15:02 Sharing Info between two workbooks? I have two seperate spreadsheets, one inventory (A) and one for customer orders (B). In (A) I have listed product name along with product number. 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)? ... 2 19.09.2006 02:53:02 Intelligent VLOOKUP I would like to program an intelligent Vlookup as follows. I have a set of data spread over 2 columns. Let us say column A is type of Food and column B is actual food-item. for example, here is a short list Column A Column B Vegetable Potatoes Fruit Orange Fruit Banana Vegetable Brocolli Bakery Bread Bakery ... 4 19.09.2006 02:42:52 Combining rows of like data? I have a spreadsheet that contains rows with multiple entries for the same item. How can I use a filter or a function to combine the values for the like items in to one row? Example: In the same chart, item number 40-011 appears three times with quantities of 5, 3, and 2. How can I filter the data so there is one occurence of 40-011 with a quantity of 10? ... 7 19.09.2006 02:03:01 criteria function using max I'm trying to set up a max function with two specific criteria. In column C I have client Age In column F I have Employee contribution Criteria: If the client is above the age of 50, the max amount they can contribute is 20000 If the client is below the age of 50, the max they can contribute is 15000 also, in column G, I have employer contribution. I need a formula so that emp... 6 19.09.2006 01:46:01 If statements This should be simple but I'm on a deadline. Need to write a formula that will provide a weighted total. I think it's an IF statement something like: IF a1=5 then * 2 (I have a table with the weights so the number 2 would be a cell reference. Just not sure of all the commas, semi-colons and parens! Help. Thanks! 5 = 5 points 4 = 3 points 3 = 2 points 2 = 1 point 1 = 1 points... 10 19.09.2006 01:07:47 cut and paste pictures in excel 2003 I would like to cut and paste pictures in excel 2003 as I did with excel 2002. It won't let me do that since I have upgraded. It is more stepes to insert a picture than to cut and paste as before. Is this going to be changed? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the... 6 19.09.2006 00:47:11 delete a # from the value axis on a column chart? A Excel Chart: trying to delete a # w/ a percentage from axis from other percentages that are on the axis. I went in to format the axis and went to the scale and changed numbers around, but will not work. It's a negative number. The chart is done the way I want it, except for this one number I want to erase?... 1 18.09.2006 23:16:01 Macro / Bob Phillips if you are out there I tried to post on the original thread but did not seem to work. Here it is again: Here's the code that I am actually using (I changed the cell reference A10 to B19). Option Explicit Sub maketable3() Dim SheetList As Sheets Dim RngToName As Range Dim LastRow As Long Dim LastCol As Long Dim NameToUse As String Dim sh As Worksheet Dim I As Long Se... 2 18.09.2006 22:50:44 837 Pages: <<  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  >>