(0.01 seconds) Articles (39890) /1995 Next>> Last >| How to open a file in another window? 1 1565 (3/30/2012 12:51:17 PM) tom5095 (21) Hi All, Before reinstalling the Ms Office 2007 I was able to open the second, third, etc. excel files simply by dragging its name to the Excel icon on the screen. So I had two or more files in separate windows... Assign Random ID 0 1669 (3/26/2012 11:44:35 PM) TesnoBay (2) I have an evolving list of names on a donor list. Evolving means adding new= names yearly. I would like to use VLOOKUP to be able to have yearly donati= ons properly updated on a master list. I know how to use... Conditional Format top/mid/bottom 33% of cells, but ignoring blank cells 0 1246 (3/25/2012 8:54:13 AM) fishyleg (1) Hello, I am trying to conditionally format the top middle and bottom thirds of a range of data. Problem is, that the range needs to be flexible as sometimes there may be a maximum of 36 cells with data, but som... Excel extract date into cell 2 1618 (3/24/2012 3:48:47 PM) tonyrulesyall (7) I am using Excel 2007 for importing data from another program. Column C always has the date in this form: 3/24/12 I would like a new column to show the following (without the quotes): "Report for Saturday, Ma... Calculating times in excel 1 1584 (3/21/2012 6:39:02 PM) coan.jim (2) I want Multiple if Statements Based upon the value in Cell AA (value is numberic 1-5). Here is the start of my formula... =IFERROR(IF($AA$2=1,(X18>R18)&TEXT(ABS(X18-R18),"hh:mm"),IF($AA$2=2,(X18>F18)&TEXT(ABS... redraw thing 3 1676 (3/19/2012 2:45:33 PM) puppet_sock (108) So my Excel app has VBA code that does a long file read and update operation. This can take up to one hour. And the client wants it to show a "please wait" message while it is doing this to help assure that it ... Trying to set Scale of 3D View in Excel 2003 0 1527 (3/23/2012 5:14:56 PM) pinkpanther (11) I have a procedure that sets the MinimumScale and MaximumScale on some 2D Surface Charts that works with out any issues. The code nested in the procedure looks like this. With ChartNorm.Axes(xlValue) ... Delete cells with content that don't contain the =?UTF-8?B?wqMgc3ltYm9s?= 1 1210 (3/23/2012 12:46:11 PM) gary.neill (2) I have a very large messy excel file that contains some data I want to isolate. The other data is unneeded and basically in the way. I want to delete/clear all the other cells that do not contain the ? pound s... Ranking, I think 2 1726 (3/23/2012 1:54:36 AM) steve5022 (5) I have a column of values which I need to rank from highest, 1, to lowest, 18. Help please as I can't find anything on google. -- Cheers Stephen ... Excel 2010: two dots 1 1501 (3/22/2012 9:39:15 AM) debrza-nospam (1) Sometimes when entering data (words) when I put a dot I get two dots: I enter prof. but I'm getting prof.. ... Highlight a cell that is a duplicate 1 1466 (3/22/2012 5:17:01 PM) bradp_xx (6) Hi I have a column where each cell has a number. There may be duplicates. Let's say A4 is 365. And A34 is 365. I would like to highlight the duplicate value in A34 but not in A4. If 365 is also located beyon... Serial time to readable time 1 1359 (3/22/2012 1:12:32 PM) sheryl.scanlon (12) How can i write a formula in excel to convert 30134 in to time like 08:22:14? ... If Then Else?? #2 0 1736 (3/22/2012 5:58:37 AM) chooky1010 (1) 1 A B C D E F G H I 2 Country MSIA SPORE HK China Japan Thai Viet 3 4 Base 0.10 0.95 0.13 0.13 0.13 0.12 0.10 (1-Bucket + 1-Crate) 5 1-Bucket 0.04 0.04 0.04 0.04 0.04 0.12 0.04 6 1-Crate... Copy/Paste problem in Excel 2007 1 1501 (3/21/2012 1:09:31 PM) Jeff9963 (48) I need to copy the data from one Excel sheet to another. But when I select, copy and paste, the new data overwrites and replaces the data in the other sheet instead of adding it to it. How can I add the data... Copy compare worksheets 1 1546 (3/20/2012 2:37:50 PM) williamthomp (20) Need some help thinking this one through. What I would like to do is copy a daily worksheet to a Weekly worksheet that will be an accumliation of the daily worksheets. The trick here is the daily information m... 2003/2007 Formula issues 1 1574 (3/20/2012 9:12:20 AM) darren.goddard (1) Hi, First time poster here. I have the following formula in 2007 which works fine. However a number of people here at work still use 2003 so I am experiencing some compatibility issues. =IFERROR(AVERAGEIF(Da... Copy Rows based on count of last row of another Column 1 1263 (3/19/2012 6:54:59 PM) williamthomp (20) Hi..I found this code on the web and it works great I just need to find a way to expand it to all the other columns without having to copy it some 26 times for each new column I want copied..Need help understan... If Then Else?? 1 1435 (3/19/2012 7:11:36 AM) nora.khoo (1) Cat Indic Apple Banana Coconut Durian Ripe (R) 10 30 50 70 Unripe (U) 60 40 20 10 Seeded (SD) 70 0 0 80 Seedless(SL) 0 70 70 0 If I have a 1 column for either Fruits (Apple, Banana, Coconut or Durian)and anoth... Calculating perfect combination of numbers to end up as close to 1700.0 as possible 1 1297 (3/17/2012 3:02:07 PM) chrisabbink (2) Hello, I'm stuck with a problem. I use the following file: http://imageshack.us/photo/my-images...culations.jpg/ (which works perfectly) The file uses MAX 15 different numbers (as seen in the IgG (g) column, ... Richiesta di Aiuto o Suggerimenti 1 1482 (3/17/2012 4:44:55 PM) a.maury1704 (2) In Excel o Creato partendo da "C1 sino a H1" una Serie di Sette per Sei Colonne di Numeri Inventati per Caso ; poi Partendo Dalla Colonna "L1 sino ad Arrivare ad R1) dei Numeri Predefiniti da me Postiin Un Unic...