Threads Replies Last Post 484 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Prevent auto date format When I paste to excel, number with hyphen '-' i.e 2-5 , automatically become 02-may. I know that format cell as text before pasting can prevent auto-date but I had a number of rows of data to paste. ... 4 12/24/2008 1:06:14 PM how do i delete using COUNTIF for specific values? i want to use a COUNTIF formula to delete cells if they contain a certain string of characters. for example, i want the formula to delete any cell that contains "_ue" the top 3 should be deleted. or instead of deleting, it could also return a value like yes/no so i could sort and delete. 48_ue13515 54615_ue1785 ao238_ue gs65fdg55 if possible i'd rather use a formula than a macro.... 3 12/24/2008 2:38:06 AM counting within date range I need to get a count month by month of the number of transactions within the month (ie all on worksheet "NEW", column O, that occur in October, Nov, etc) I tried using COUNTIF and it worked for one month using: =(COUNTIF(New!O:O,">=10/01/2008"))-(COUNTIF(New!O:O,">10/31/2008")) but not in the next using essentially the same thing: =(COUNTIF(New!O:O,">=11/1/2008"))-(COUNTIF(Ne... 3 12/23/2008 11:24:22 PM Cannot see multiple cell selections When I want to copy, cut, or select a range of cells to see totals or averages etc. the automatic fill color of the selected cells is so faint that I can't see which cells I've selected. Is there a way to darken the fill color of selected cells? ... 1 12/23/2008 9:39:02 PM Conditional Formulas I am working on a workbook where I would like to use a different formula depending on the result of a cell. This without using an if/then statement. That is, if the result of sheet2.C1 > 0, then the formula in A1 would be "=K5" If the result of sheet2.C1 = 0, then the formula in A1 would be "=S5" I can't use a simple if/then statement such as if('sheet2'!C1 > 0, K5, S5) because s... 5 12/23/2008 8:58:32 PM PDF Lookup Hi, I've been working on a project for a couple months and have one last addition to it that I can't quite figure out. I have created a dropdown list of 200+ numbers that correspond to pdf's we have. Is there a way that by selecting a number I can get the corresponding pdf to appear on a seperate tab? As of right now we are having our employees select the pdf via hyperlink, but if it wa... 1 12/23/2008 4:32:01 PM evenly distribute numbers across a range I'm trying to create a formula or script that will accomplish the following Lets say I'm going to sell 7 apples over the next 12 months I'm trying to create a script that will evenly distribute the 7 apple sales across the 12 months I cannot sell part of an apple so the numbers must be zero or one(this is what has me jammed up) The script will allow for more than one apple to be sold in a... 2 12/23/2008 6:58:17 AM Excel Worksheet Oddity I have a worksheet in Office Home and Student 2007 that seems to exist within another worksheet. The Ribbon surrounds the main data sheet so that the Save Icon is below the Start Icon, etc. -- JMorgNU... 3 12/23/2008 2:42:00 AM Urgent! Help needed for Excel Hi all, I need your help. I have an Excel sheet, where we used a 3rd party API and called a function. So each cell has a function call to retrieve some data from some database. We have successfully collected data from the database. And we now no longer have access to the computer which is equipped with the API and database, due to expiration of trial period. And after we collected dat... 6 12/23/2008 1:17:44 AM Selective pasting with Format Painter We have seen many threads recommending the Format Painter be used to copy specific formats or styles to other cells. Unfortunately, we cannot find how to specify which specific attributes are copied or which are pasted? Does the Format Painter only copy ALL formats (color, font, outline, number, conditional format, etc.) or can it be used to copy a specific single attribute of the forma... 7 12/22/2008 9:11:03 PM Help Excel 2007 - worksheet scaling not working Hoping that someone can help with this. I'm trying to print out a small worksheet on a '11x17' sheet. I've set the print area to the size I want and I have the scaling set to scale to '1 sheet wide x one sheet high' and the layout to 'landscape'. But there's no scaling happening. Cells still show up in a small corner of the sheet. I've never seen this behavior in any previous versio... 5 12/22/2008 5:03:29 PM Filter rows/transactions to another sheet. Hi I have a sheet with 6500 transactions in rows. Each row contains an account no, amount, etc I would like to have Excel automatically copy all the rows/transactions on each account to a separate sheet in the same workbook (one account per sheet). And I would like this to be done automatically for each account in the original sheet. I have tried Vlookup, but it does not seem suitab... 4 12/22/2008 4:56:23 PM Formatting Times and converting to text Hi, I have got a spreadsheet which has a column which holds a time calculated from another column. The times in both columns are in the format m:ss.000. The sheet when complete will be imported into Access which unfortunately xan't hold times with seconds with 3 decimal places so the recomended solution is to hold the time in a text field. So how in Excel can I convert the times into... 4 12/22/2008 3:20:03 PM "The data on the Clipboard is damaged." For years I've pasted some data from an Excel .CSV to an Access form. Starting the day I installed this weeks patch bundle, I get the following message from Access on attempting the paste: "The data on the Clipboard is damaged, so Microsoft Office Access can't paste it. There may be an error in the Clipboard or there may not be enough free memory. Try the operation again." Pasting t... 12 12/22/2008 12:23:01 PM invalid product key-code Good morning, Starting from an application “VB6” our software has generated an excel file through the creation of the object “Excel Application”(Code: CreateObject “Excel.Application”). Since today we never had any kind of problem about that, but some days ago the software has begun to give a message error “Good morning, Starting from an application “VB6” our software ha... 1 12/22/2008 7:51:13 AM Invalid product key-code Good morning, Starting from an application “VB6” our software has generated an excel file through the creation of the object “Excel Application”(Code: CreateObject “Excel.Application”). Since today we never had any kind of problem about that, but some days ago the software has begun to give a message error “Good morning, Starting from an application “VB6” our software ha... 1 12/22/2008 7:46:00 AM Loan - Extra payment benefit formula Hi, I have the following criteria: Outstanding principal: 616, 000/= Interest Rate: 13.25% Remaining tenure: 22 months Monthly Payment: 31, 672/= Lets say I increase my monthly payment by 2,000/= then what would the benefit (savings in interest and decrease in payment cycle). I know there are some web based tools that will allow me to calculate this. I'm looking for a formula to per... 3 12/22/2008 2:57:59 AM getting cell color to allow alternating blocks of like value == like color cells I have seen this asked a few places and some answers, but nothing that works. I want to simply alternate the color of a col so blocks of identical values have the same color. Thus A black A black B blue C black C black A blue B black C blue C blue C blue If you could get the cell color in a formula you could do it painfully as in a formula for black and a formula for blue ap... 5 12/21/2008 10:50:47 PM Office Excel How do I open Office Excel from the desk , or from a map. in Office 2003 you could open Excel by right klick and then open it. but in Excel 2007 you dont have that choise, why?... 1 12/21/2008 9:56:01 PM Change 3rd cell colour based on cell 1 >= cell2 in range Hi all - I have looked through the group for a solution to this particular problem but i think my inexperience is possibly stopping me from seeing the solution .. so apologies if it has already been answered many times previously. My problem is this : I have two columns Col1 = Cumulative Sales and Col2 = Cumulative Target and a range of 1 - 31(signifies the days of the month). I have ... 9 12/21/2008 9:41:56 PM Pecentage Reduction In column A I have a list of numbers in the format:- 5 4 3 2 1 0 -1 -2 -3 -4 -5 Any cell in column A can contain the above values. In column B I have another set of numbers, all positive values. In column C I would like to see displayed a modified version of column B dependent on the value of A. Put simply, I would like the value of B1 displayed in C1, but reduced by 1... 10 12/21/2008 7:08:23 PM creating hyperlinks I have a large column of names which I want to change into hyperlinks. The link should open a file which name is the same as the content of the cell, only it has an extension added. The file is located in the same directory as the excel file. F.e. lets say the contents of cell A1 is "contentA1". Now cell A1 should be changed into a hyperlink that opens file 'contentA1.ext' on clicking it. O... 3 12/21/2008 6:08:08 PM How do I keep one part of a formula constant? I am looking to find the numbers of days between two dates. G2 will have the current date and there will be multiple entries in column E. I know how to find the number of days, G2-E4 gives me what I want but when I copy the formula to get G2-E5 it changes G2 to G3. How do I keep the G2 portion constant? Thanks to all in advance. ... 4 12/21/2008 2:56:33 PM Excel macro concatenate each 2 rows data into 1 row for all sheet Hi all, I have an excel sheet of 12000 rows of datas and I need to concetenate the datas in each 2 rows into 1 row with fixed size and delete the previous ones if possible or to create a new sheet with the concatenated datas to the same workbook. Eg: Before A B C D E ... 1 Data1 Data2 Data3 Data4 Data5 2 Data6 Data7 ... 3 12/21/2008 2:22:13 PM formula help. I have a number of formulas in my weather spreadsheet but I want to combine a couple and seem to be getting in a bit a muddle, I wonder if someone could help. Basically I have a column that converts wind speed from m/s to knots after determining the maximum value, this works fine until this entry is missing (no report), the formula then returns '0'. In these such cases I would like it to r... 6 12/21/2008 1:22:11 PM 484 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>