Threads Replies Last Post 837 Pages: <<  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  42  43  44  45  46  >>   Information changes daily We have four shifts that rotate between days, swing, and graveyard. There is always one shift off. We also make a variety of products and lengths (each day the production schedule changes). Right now, I manually fill out a punch sheet representing the day's production and I am trying to put the punch sheet into Excel and have the information transfer from three worksheets. The proble... 5 16.09.2006 02:47:01 Amount to text Hello, Is there a formula to take a currency value in one cell and have it spell out the amount? If in one cell I have $28.32 is there a formula to have it put in Twenty Eight and 32/100 like in a check? Thank You JCLSB ... 2 16.09.2006 02:28:11 Formula Help Hello, I have a mileage form that in col C list multiple cost centers and in col D the user has to enter their cost center again so the calculations will work. I'd like a formula that will pull the cost center in C only once so there is a total of mlg being claimed per cost center. Example: A B C D E 10 miles 09/01 611 61... 11 15.09.2006 23:47:01 truncate numbers from millions to thousands I was given a spreadsheet in millions and I want to convert all the numbers to thousands. (ie $1,538,498 to $1,538) How do I go about doing that. Version = Microsoft Excel 2003, SP2 Thanks,... 4 15.09.2006 23:09:01 How do I count something in one column = to info in another Ok lets make my question more clear.. In column "A" I have Supplier, or CFAC, or EM&T. In Column "D", I have any letter A through Z and any number 1 through 9. If I want to count everything = to "Supplier" in column A that have and "E" in in coulmn D, how do I write the formula. I am adding this to an existing spreadsheet that a lot of people change things in and I want the cou... 3 15.09.2006 23:03:01 Return position for each matching value in entire workbook? Is there a function or command for a cell in a worksheet that results in a search of the entire Excel workbook and which then returns (in the worksheet) the full value / content of each cell in the workbook that matches the criteria of the search. For example, on one worksheet I want to see every cell (in its entirety) of the workbook that contains a particular number or phrase.... 2 15.09.2006 22:36:57 Selective linking items between two worksheets I am weakest in excel; I have an understanding of VBA in Word and I have attended an advanced Access course. I have this problem in excel, I have no idea what track to take with it, Hence the cross posting between programming and worksheet functions. This workshbook is to be used by our surveyors to input data from site inspections. I have a table on one worksheet with the column he... 10 15.09.2006 22:20:13 Drop and drag is copying values instead of formulas Why would this happen?... 6 15.09.2006 22:01:34 Bold How do you make Character "B" Bold Sub BonusNumbering() Dim cell As Range Dim lRow As Long Dim lColumn As Long Application.ScreenUpdating = False For Each cell In _ Range("AW2:AW" & _ Range("AW65536").End(xlUp).Row) lRow = cell.Row lColumn = cell.Value + 1 Cells(lRow, lColumn) = "B" Next 'cell Application.ScreenUpdating = True End Sub With Tha... 4 15.09.2006 22:00:30 how_to_calculate_5‰_of_1250 how to calculate 5‰ of 1250 with MS Excel?... 4 15.09.2006 21:47:59 Calcualtion of renewal I want to create an automatic renewal for calcualtion of depreciation after x years. To explain this is what I want it to look like. I want a formula for this No; of Years Year 1 Year 2 Year 3 Year 4 Year 5...... Year 30 3 Years 4 Years 5 Years 7 Years 10 Years If a asset is purchased in the first year it will have to be renewed at the end of 3 years, or 4 year... 1 15.09.2006 20:11:56 Calcualtion of renewal I want to create an automatic renewal for calcualtion of depreciation after x years. To explain this is what I want it to look like. I want a formula for this No; of Years Year 1 Year 2 Year 3 Year 4 Year 5...... Year 30 3 Years 4 Years 5 Years 7 Years 10 Years If a asset is purchased in the first year it will have to be renewed at the end of 3 years, or 4 year... 1 15.09.2006 20:11:54 VLOOKUP RETURN BLANK Here is the formula that I am using. =VLOOKUP(G7,$G$70:$H$89,2,FALSE) It works fine but I want the cell accepting the result (G8) to be blank when G7 is blank. Then return a correct value when G7 has a value in it. (This part works.) I have a drop down list in G7 and when I pick the blank cell in the list G8 returns #N/A I understand why it does this, I just don't want it ... 4 15.09.2006 19:52:23 Data Validation Lists I am filling text into a cells by using Data--Validation--Lists. This won't let me enter anything in the cell that is not on the list. Is there any way to just write something different right in the cell (that is not on the list)? OR is there a better way to accomplish fby using a different procedure thanks Raymond. -- dzierzekr... 2 15.09.2006 19:43:33 using vlookup for words w/different indentation Hi, I'm trying figure out a way to use a vlookup function when the word in the table is the same but indented differently. For instance, you're looking for the price of an 'apple' but the word 'apple' in the table is actually written ' apple' with 4 spaces in front of the word. I was trying to use the 'Right' function but the number of letters my vary. Thanks for your inputs.... 4 15.09.2006 19:39:02 Cell with zero to appear as empty Is it possible in Excel 2003 to make a cell with a formula, that has the outcome zero, to appear as an empty cell? I am making a line graphic but I want the cells with zero not added in the graphic. How is this possible? -- Ewout... 6 15.09.2006 18:54:02 i need the sheetname in my cells I am using numbers for sheetnames and I need them in a cell in this way =VALUE(RIGHT(CELL("filename";A3);2)) Is there any another way to put the sheetname into the cell? ... 6 15.09.2006 17:35:04 Permutation combinations and multiplying them hi, Although i understand permutations i cant find a quick and easy way to multiply all the combinations for a permuation. Doing it long hand works but is time consuming as i currently have 2 rows with a total of 165 combinations. In row 1 i have 10 numbers, perming 8 from 10 giving me 45 combinations, perming 7 from 10 giving me 120 combinations Is there an easy way to multiply th... 6 15.09.2006 17:27:10 how to set auto protect workbook on exit? -- West, Langkawi Island, malaysia... 3 15.09.2006 17:05:31 Count Only Empty Cells AFTER Cells with Data I have a constant range of cells D8:D31 (two periods per month) on each sheet where I need to get the number of cells with data, and the number of blank cells AFTER cells with data. (I don't want to include the empty cells before the sales data starts). I need to do a projection of sales for the balance of the year and need number of months with data and the REMAINING months without data... 3 15.09.2006 17:05:01 Subtotal by Account (cash, liability, revenue, expense) in Excel? I am trying to get subtotals added to a trial balance report. The report has the account numbers listed first and show a list of account numbers. With each change in the first number the group change. How can I subtotal all the cash, liability, revenue, expense............?... 3 15.09.2006 17:02:02 Serial Numbers converted to text string Please help. I want to convert a date serial number into a long date text string so that I caan incorporate in a concanenated statement. Whenever I use a cell wher i think I have done this the value that appears in the concat statement is the original serial number Thanks ... 4 15.09.2006 16:59:47 Field List in Pivot Table Not updating Ok, I have looked but can't find the answer I am looking for. Background: There was a pivot table created which is linked to either a sheet in the same workbook or I have also linked it to an external datasource which has the same dataset layout and fields. I have the need to create multiple sets of this pivot table and change the actual dataset that it uses. I don't have any problem... 3 15.09.2006 16:56:02 Possbile for non-contiguous vlookup? Good afternoon - I have a order entry file I'm trying to enable the possibility for offering quantity breaks. However, the different items to be sold have different levels of qty breaks. For example: Item Qty Price Break1 Break1Price Break2 Break2 Price a 1 100 5 90 10 80 b 1 200 8 180 ... 6 15.09.2006 15:40:56 IF statement formula Hi Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks... 5 15.09.2006 15:12:53 837 Pages: <<  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  42  43  44  45  46  >>