How to open a file in another window?11505 (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 ID01614 (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 cells01179 (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 cell21557 (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 excel11522 (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 thing31614 (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 200301454 (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) ...
Ranking, I think21681 (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 dots11433 (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 duplicate11407 (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...
If Then Else?? #201668 (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 200711439 (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 worksheets11498 (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 issues11505 (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 Column11200 (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??11359 (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...
Richiesta di Aiuto o Suggerimenti11433 (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...