Functions
in [Excel]
|
answer Did you every find the problem? Bill Johnso wrote: xlbgnm in remote data 07-Apr-09 I have an xls (2003) excel spread sheet that calls data from another application (DDE) like this: =RSLINX|'PC2'!'ANA[201]' and like this =Rslinx|'EC2'!ACT01 This is standard DDE, and in 2003 and earlier it works. The prob... 22 Apr 2010 15:34
looking for a function that will populate opening a worksheet I don't think will solve the problem, I use excel's functions and formulas all the time, but I am looking for something more advanced. There is not always an dollar amount to entered into the cell. I did try using the Data Validation, which gives me a warning or a pop up box. I thinking I may need a macro of ... 22 Apr 2010 15:34
why this strange result with vlookup hi i have this formula in a cell =VLOOKUP(A3,'LookUp Data'!A2:O740,2,FALSE) but any time i pick a code from my list items in column A it gives #NA but as soon as i change to a different code it gives the name. any help why ... 22 Apr 2010 19:45
Percentages in Pivotal I have a pivot table I want to do percentage of total on: Column 1 Column2 Ice Cream 32 Cake 50 Total 82 I want to add a third column that says 32 is 39% of the total 82. And 50 is 61% of the total. The system should be able to calculate this. I tried to do a search ... 25 Apr 2010 06:36
When refreshed, some Pivot Table columns retain formatting, some d I have not had trouble with retaining column widths and column heading formats (font size, word wrap, alignment) in Pivot Tabl. When refreshed, they retain formatting. Here's the weird part, when I add or insert a new data column into the Pivot Table by checking from field list, that new data column does not ... 22 Apr 2010 13:29
multiple IF calculations I've figured out how to make cell X display the number of hours entered into D9 if the text "Stat Worked" appears in D11, but now I need to do the same for columns E through Q, and sum the results. =IF(D11="Stat worked", D9, 0) Any thoughts? ... 22 Apr 2010 14:31
Excel - How to get tab to go to next unlocked cell across columns Is there any way to use Excel as a form for data entry and have the enter and/or tab key take you to the next cell for data entry when the next cell. Specifically, I have a form setup and it has merged fields at different places. I need the ability to enter across a line and at the end of that line for the ne... 22 Apr 2010 16:37
Default Cell value in changing environment I don't know if this is possible to do, but I figured I'd ask. I have a workbook where the first worksheet populates data on employees based on their name selected from a drop down cell. All of the data populates fine here. There is one cell that is a subjective rating decided upon by managers (Coaching Scor... 22 Apr 2010 14:31
identify the numbers cancelling by amounts Hi, can anybody help in the below query i have the below data with me RECEIPT_NUMBER TRX_NUMBER Amount Comments 9907893007 7000604737 151.06 Nil 9907893007 7000604737 175.51 Bill 9907893007 7000604737 -151.51 Nil 9907893007 7000604737 -151.51 Nil 9907893007 7000604737 -151.06 Nil 9910789407 7000857919 4,23... 22 Apr 2010 11:23
Centreing Text In Excel Cells I am send data to an Excel Spreadsheet, which includes some numeric data and some text data. I want to have the text in all columns in the centre of the cell. I have tried lots of different code:- xlSheet.Range("A:L").HorizontalAlignment = HorizontalAlignment.Center xlSheet.Cells.HorizontalAlignment = Horizo... 22 Apr 2010 11:23 |