Threads Replies Last Post 1369 Pages: <<  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  42  43  44  >>   divide Can any body tell me why when I go to divide with the MOD function it does not work ?? I am trying to use a1((100)) and divide by 2 . anwser is 50 Does the divide function array work ??? If I try and type in mamual it works (( =a1/2 it works ????... 3 22.09.2006 01:34:26 Empty Date Cell as Zero I am trying to tie a formula to a cell that contains a starting date. However, when this "starting date" cell is empty, I want the corresponding formula to read it as zero. Because the "starting date" cell is formatted as a date, the corresponding formula seems to still show blank cell as having a default date in it, and returns a value for that cell. How can I make this blank cell be rea... 2 22.09.2006 00:09:13 UDFs return #NAME error sometimes, other times, they work So I have a spreadsheet with a bunch of cells that use a UDF. Sometimes when I open the spreadsheet, some of the cells that have this UDF show a #NAME error. Pressing F9 seems to clear these errors. Is there some setting which forces UDFs to calculate automatically? This is the code I'm using, if curious: Function GetFormula(Cell As Range) As String GetFormula = Cell.Formula ... 5 21.09.2006 22:52:44 Date and Time Picker Does any one know where Microsoft Date and Time Picker has gone in Excel 2007, has it gone for good?... 3 21.09.2006 22:47:59 EXCEL 2007 B2TR ERROR In some cases, when copying a cell (formula) to other location the relative references are no updated. For instance: cell B3 = A3. When I copy B3 to B4 the formula remains A3 (instead of A4). I have a file to show the problem. I just do not know to whom should I send the file. -- rc... 4 21.09.2006 22:04:17 Which Statistical Analysis Should Be Used Hello All, I am hoping someone could help me in deciding what statistical function should be used if I want to know cumulative amounts. For example, if I am looking at reports that are made daily by my team. I would like to know how many reports are being added daily. Btw, I would be working within an Excel spreadsheet. So I might see for example, 29 reports entered one day, 35 re... 1 21.09.2006 21:55:23 How to sort al list in random order for sampling? How can I sort an Excel list into random order to facilitate drawing a sample of the items on the list? ... 2 21.09.2006 21:50:24 Copy Paste... arg... I have a cell with a formula in sheet1 which points to another worksheet cell (sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I tell it to just copy paste normally without excel changing my formula targets?! thanks!... 6 21.09.2006 21:50:01 How to use validation formulas in Combobox What I want to do is for when the user selects a cell, a combo box based on the field name pops up for better viewing and autocomplete, after a couple of keystrokes the selection is complete and a {Tab} or {Enter} key will populate the cell and it will be validated and move to the next cell. I have the data validation and movement working OK but the ComboBox is driving me batty. The dat... 2 21.09.2006 21:19:02 Concatenate Function I understand how to use the concatenate function to merge several cells with text into one cell. My question is this: after the concatenate function merges the specified cells into one cell, how can you then put spaces between the text strings? For example, say the concatenate function merges the following cells: firstname, lastname, and age. The result of the concatenate function would... 4 21.09.2006 21:08:22 excel formula - possibly visual basic method I need to set up a quite a complicated spread sheet. This is the senario: say my sales figure for monday is £50 (which is my target). However my actual sales figure for monday is £40. How do i get the cell to show the difference between my forecast(target) and my actual having predefined the cell with my target sales figure so that when i type the actual sales figure in it will automat... 3 21.09.2006 20:55:21 Database (or the like) from Excel Sheet I have an excel sheet that looks like the following style weight1 weight2 x 1.5 2.5 y 1.7 2.9 z 2 3.1 and so on (except that my database has over 1000 styles with weights, etc) What I want to do is build a simple database that when I search for y, for example, it will return to me the weight 1 and weight... 4 21.09.2006 20:52:48 How do you convert decimal degrees to degrees minutes seconds Is it possible to convert decimal degrees to degrees minutes seconds in Excel?... 3 21.09.2006 20:38:02 Does anyone have access to an audit toolbar? I would like to add an audit toolbar to excel . . .one which has standard tickmars, etc. Does anyone have access to such a tool bar?... 1 21.09.2006 20:31:02 conditional formating how do i set conditional formating so in the column which show gender i will have M for male and F for female... 2 21.09.2006 20:28:15 Conditional Formatting of merged cells, borders don't show correct In Excel 2000, on merged cells I am using conditional formatting to apply formatting including fill color and borders. On some cells the borders only show on part of the merged cell. It may appears like the border is only on the first cell of the merged cells. How do I fix?... 6 21.09.2006 20:23:37 How can I exit a workbook in Excel without closing the program? ... 2 21.09.2006 20:19:06 Horizontal Scroll will not work in Excel 2007????? I have no other issues with the horizontal scroll not working in any other 2007 programs but Excel. It worked for me in 2000 and 2003 but will not now. Please help? Or is this a known issue?... 4 21.09.2006 20:16:01 percentage? my question is i am trying to find the percent of an average. ( i have a spread sheet of 14 people) I am trying to get an 'average' percent of all their combined percentages. WHen some employees are not at work then i leave thoese colums blank and i receive an erro # DIV/O! and my percent total at the bottom, also reflects the same error. I'm sorry if i'm confusing, but right now i'm confused... 3 21.09.2006 20:12:02 Copy macro to another workbook Hello, I greatly enjoy "playing" with macro's in excel created by recording my actions; I have no programing back ground so I'm afraid Visual Basic is a mystery to me. I have recorded macros which I would like to use in other workbooks without the original workbook being available. Basically I just want a way to copy a macro from one workbook so that I can use it in another. Thanks in an... 5 21.09.2006 19:48:26 Summary Sheet help with multiple sheets I have an excel workbook with multiple sheets. (Let's say that Sheet 1 is the summary sheet and sheets 2, 3 and 4 are the sheets in which data is entered) I want the information from sheets 2, 3, and 4 to come into the summary sheet (sheet 1) in the order that they are entered. For example, if I enter information in sheet 2 on 9/20/06 at 4:00 PM and enter information in sheet 3 on 9/21/06 at 9... 2 21.09.2006 19:40:17 Excel 2003: Autofilter I have a spreadsheet in which I put an autofilter on one row. There are 15 columns in that row and it makes sense to only put an autofilter on one column, n ot the other 14. Is there a way to do this? Currently, all the columns in that row have this little dropdown arrow box.... 2 21.09.2006 19:39:02 What does Microsoft want me to do? When I installed MicroSoft Office 2003 Teacher and Student, it did stupid things to my ability to use MicroSoft Works on my machine. One of these is a request to Register my software when I call up an XLS file for Works Spreadsheet. When I click on Register to get rid of the notice, I get this page http://register.microsoft.com/regsys/regsys.asp?wizid=4538&lcid=1033 which produces a 4... 2 21.09.2006 19:37:02 how to export a file to my documents as XML data type ... 1 21.09.2006 19:33:02 'The process cannot access the file because it is in use by anothe I receive the following error message when I try to open a Excel document on a network share: 'The process cannot access the file because it is in use by another process' I am not able to copy it nor open it. Usually if someone else had it open I would be given the option to open a 'Read Only' copy. Ideas?... 1 21.09.2006 19:24:01 1369 Pages: <<  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  42  43  44  >>