MSGROUPS.NET | Post Question | Search | About | Groups | Contact | Register | Login



microsoft public excel misc (5666)

microsoft public outlook general (4816)

microsoft public excel programming (4187)

microsoft public word docmanagement (3506)

microsoft public excel worksheet functions (3180)

microsoft public access (3139)

microsoft public windowsxp general (2033)

microsoft public windows vista mail (1618)

microsoft public office misc (1571)

microsoft public windows vista general (1507)

microsoft public windows live mail desktop (1354)

microsoft public access queries (1319)

microsoft public powerpoint (1268)

microsoft public access formscoding (1206)

microsoft public mac office entourage (1193)

microsoft public dotnet languages csharp (1174)

microsoft public access forms (1153)

microsoft public internetexplorer general (1123)

microsoft public access modulesdaovba (1065)

microsoft public windows server sbs (1060)

microsoft public greatplains (1045)

microsoft public mac office word (1018)

microsoft public outlook calendaring (961)

microsoft public excel (928)

microsoft public sqlserver programming (897)

microsoft public project server (874)

microsoft public windowsupdate (812)

microsoft public windowsxp help and support (798)

microsoft public windowsmedia player (781)

microsoft public project (772)

microsoft public mac office excel (759)

microsoft public access reports (758)

microsoft public exchange admin (747)

microsoft public dotnet framework aspnet (736)

microsoft public sqlserver server (700)

microsoft public outlook (697)

microsoft public outlook contacts (678)

microsoft public dataprotectionmanager (659)

microsoft public word vba general (635)

microsoft public windows server general (628)

microsoft public windows server active directory (586)

microsoft public outlook installation (580)

microsoft public word newusers (560)

microsoft public publisher (517)

microsoft public excel newusers (507)

microsoft public excel charting (499)

microsoft public word pagelayout (494)

microsoft public dotnet languages vb (464)

microsoft public vb general discussion (457)

microsoft public development device drivers (444)

microsoft public office setup (430)

microsoft public word application errors (428)

microsoft public sharepoint general (426)

microsoft public windowsce platbuilder (409)

microsoft public access gettingstarted (407)

microsoft public windows powershell (400)

microsoft public frontpage client (391)

microsoft public onenote (391)

microsoft public sqlserver reportingsvcs (382)

microsoft public outlookexpress general (369)

microsoft public access tablesdbdesign (352)

microsoft public pos (352)

microsoft public vc mfc (346)

microsoft public outlook program vba (341)

microsoft public windows live messenger (324)

microsoft public money (309)

microsoft public windowsxp hardware (299)

microsoft public windows 64bit general (295)

microsoft public scripting vbscript (289)

microsoft public windowsxp basics (236)

microsoft public windows mediacenter (230)

microsoft public dotnet general (225)

microsoft public mac office (198)

microsoft public nntp test (195)

microsoft public windows inetexplorer ie6 outlookexpress (191)

microsoft public windows vista music pictures video (153)

microsoft public win98 gen discussion (153)

microsoft public sharepoint setup and administration (139)

microsoft public windows vista hardware devices (130)

microsoft public dotnet framework (104)

microsoft public windows vista performance maintenance (97)

microsoft public visio (89)

microsoft public access 3rdpartyusrgrp (73)

microsoft public dotnet xml (59)

microsoft public access conversion (56)

microsoft public pt windowsxp (36)

microsoft public windows live photogallery (32)

microsoft public access developers toolkitode (31)

microsoft public dotnet faqs (15)

microsoft public dotnet framework aspnet datagridcontrol (10)


microsoft.public.excel Post New
Items(927) /10 Next >> Last >|
Subject Posted Replies From
conditional formatting & formula

Hello I'm working on a spreadsheet and would like to highlight the highest value across. i.e. Name 1 2 3 4 5 6 7 Mary 1% 2% 2% 25% 45% 15% 10% These are the student's probabilities to achieve grades 1 to 7 I'd like a conditional Format to highlight the highest probability, in this case 45% I would also like a column on the right of 7 to show the grade that corresponds with the highest probability in this case 5. which may have to be a formula Appreciate any help on this

3/10/2010 7:41:44 PM 4 "Dingbat" <askingm...@questions>



Delete Range of cells and move left based on Cell value

Hi..I am trying to delete a range of cells in a column and move them left based on whether or not a certain cell = 0. Any help would be great, thanks, Bill

3/10/2010 4:42:56 PM 3 Thomp <williamth...@gmail.com>
Count Tick Marks from Code given by Jacob Skaria

I got this code from Jacob and now I need to know how to tally the columns and give a percentage of how many "x" marks were made. I am using Excel 2007, and no absolutely nothing about code, except maybe how to paste. Here is the code: Another workaround with fonts. Single click on any range to check/uncheck. 1. In the required range (suppose ColD) in all cells enter small letter "e". 2. Select all cells in that range and change the font to Marlett. 3. Adjust the column width to look like a square check box 4. Right click on the sheet tab and hit view code. Paste the below code

3/10/2010 4:32:09 PM 1 Cindy Renea
VBA Question: Formulas and Range variables

I've got a good background in Visual Basic, but am new to VBA for Excel.My question is, if I have 2 ranges of data, how do I assigne a formula to a third range? Here is a simplifed example of what I'm trying to do. A B C -------------- 12 | 23 | formula using A1 & B1 values 21 | 24 | same formula using A2 & B2 values I'm using the following code to select an entire column (not very efficent, but it's day one of VBA for Excel for me): Dim RangeA As Range Set RangeA = Application.InputBox _ (prompt:="Select Device Identifier Range:", _ Title:="Device Identifi

3/10/2010 3:25:12 PM 5 CratoDefrog <...@pound.com>
Subtracting/Adding dd:hh:mm:ss

I am receiving data from several counters on field generators. The time is in dd:hh:mm:ss. I am needing to calculate the run time on the equipment from one day to the next and then sum the total time run for the week. I have created a custom format for dd:hh:mm:ss for each reading but the subtraction (for calculating the daily run time) or addition (sum of daily run times) formulas are not working. Help please! -- Lucy

3/10/2010 2:24:01 PM 7 =?Utf-8?B?THVjeQ==?= <L...@discussions.microsoft.com>
PIVOT TABLE - Show Dates in months

Hi, I've got a list of items all with associated dates - I want to create a pivot table that will count the number of items for each calendar month - how can I change the display on the pivot to reflect the month? Dave

3/10/2010 2:09:03 PM 3 =?Utf-8?B?RGF2ZSBFYWRl?= <DaveE...@discussions.microsoft.com>
Transpose large data from columns to rows

Hello thanks for the help if possible. I have 2 columns. Column A contains names of employees column B contains the trainings the employees attended. Each employee has different number of trainings (I got this data sorted by simple pivot table) A B Employee X training 1 Employee X training 2 Employee X training 3 Employee Y training 3 Employee Y training 2 Employee Z training 5 Employee Z training 7 Empl

3/10/2010 7:30:28 AM 3 Klemen25 <kleme...@gmail.com>
XL Sheet Display

Hi, I am using Excel 2003. For some sheets I do not want the Row & Column Headers showing, so in Tools > Options > View then in the "Window options" I uncheck the box "Row & Column headers". By doing this I can set each sheet individually. Some have the headers showing others not. What I want to do is a similar thing for the "Horizontal scroll bar" and also the "Vertical scroll bar" settings. However when I uncheck these boxes, the scroll bar for ALL sheets is not shown. I cannot set each sheet individually, ie some showing and some not showing the scroll bars.

3/10/2010 6:45:29 AM 3 "someone" <some...@home.com>
Expand list in Excel.

Hi. I had made a list menu (Validation data, drop down list etc.) in an Excel sheet. I would like now to expand (to add new cells with extra data) to the list. I tried to do this but I couldn’t . Is it possible ? How? (I don’t want to write the total workbook again from the beginning) Thank you.

3/9/2010 8:28:01 PM 2 =?Utf-8?B?R2Vvcmdl?= <Geo...@discussions.microsoft.com>
Average Formula

I'm trying to find the average of bulletins used each Sunday. I'm keeping track of how many I produce each Sunday and how many are left. Basic table... Week Bulletin Amt. Bulletins left Week 1 100 34 Week 2 100 17 Week 3 110 20 I'm keeping track for the year (52 weeks) What kind of formula would I use? Thanks, wiersma7

3/9/2010 5:26:19 PM 2 "wiersma7" <off...@parkwoodchurch.com>
Automatically closing slave workbook when main workbook is closed...

Hi Have two workbooks - lets call them workbook1 and workbook2 for ease. Workbook 1 is the main document, however, some of data is drawn from Workbook 2 which is currently mininmized by following code in VBA Workbook1: Private Sub Workbook_Open() Workbooks.Open "Workbook2.xls" ActiveWindow.WindowState = xlMinimized End Sub Ideally I would like Workbook2 opened and hidden so that user does not even know it is running and then shut down automatically when Worokbook1 is closed. PS - when Workbook1 is saved it will be renamed, however Workbook2 title will stay static. tha

3/9/2010 11:48:54 AM 0 Potsy <stu...@batchelor-electrical.co.uk>
Automatically closing slave workbook when main workbook is closed...

Hi Have two workbooks - lets call them workbook1 and workbook2 for ease. Workbook 1 is the main document, however, some of data is drawn from Workbook 2 which is currently mininmized by following code in VBA Workbook1: Private Sub Workbook_Open() Workbooks.Open "Workbook2.xls" ActiveWindow.WindowState = xlMinimized End Sub Ideally I would like Workbook2 opened and hidden so that user does not even know it is running and then shut down automatically when Worokbook1 is closed. PS - when Workbook1 is saved it will be renamed, however Workbook2 title will stay static. tha

3/9/2010 11:46:54 AM 0 Potsy <stu...@batchelor-electrical.co.uk>
VBA Syntax problem

I am trying to set up a macro which would only run if there is a value in any of the three cells to the left of active cell. The following does not seem to work and would appreciate any help in correcting this: If ActiveCell.FormulaR1C1 = "(SUM(RC[-3]:RC[-1])<>0" Then run macro code End If JP

3/9/2010 9:47:23 AM 1 "JP" <D...@nomail.com>
Excel 2010 (beta)

I am running Excel 2010 beta and have managed to install the Data Mining pack. However it needs to be connected to the localhost to work. Not being into networking, I find this aspect of things quite daunting. Clicking on the data mining tap shows that I have no connection on the 'connection' icon. Clicking on the connection icon brings up the 'new connection' window. I clicked 'new' and typed in 'localhost'. clicking on the 'catalog name' drop-down list prompts the software to look for a connection. I then get an error message, 'A connection cannot be made. Please m

3/9/2010 8:27:31 AM 0 Saxman <john.h.williamsREMOVET...@btinternet.com>
Help!! urgent

I was using Excel 2007 quite happily, and must have hit something on the keyboard, because now every time I touch keys windows spring open and I am powerless to do anything on my spreadsheet. I have tried restarting the computer. How do i turn off this feature?

3/9/2010 3:21:01 AM 1 =?Utf-8?B?QW50aG9ueSBC?= <Anthony ...@discussions.microsoft.com>
putting a set of values into a group of bins

I have a column of numbers and I want to count how many are between 1 and 10, 11 and 20, 21 and 30, etc. I have been unable to develop any expression for the COUNTIF function or a pivot table that works. Is one of those the way to go, or is there another alternative. Thanks Elliott

3/9/2010 1:01:25 AM 4 Elliott Alterman <ealter...@suddenlink.net>
show with messaje box when it's time and date

HELLO FRIENDS NEED HELP I HAVE THE COLUMN (A) The time to write date and hour Next notice /Alarm, I need Warn me when it's time and date of notice/alarm start up show with messaje box Message with the message that I write in the same row of column ( B) in the same row EXAMPLE: A B 1 26/04/2010 10:00 AM payment LIGHT 2 03/05/2010 4:20 PM Remember payment Phone 3 06/04/2010 8:40 AM Appointment with Dr. Saludo KM**VE

3/8/2010 10:42:07 PM 1 "KM**VE" <NOkaledmouradS...@NOhotmailSPAM.com>
External Data wont refresh on a prtected and shared workbook...

I have a workbook that is used by multiple people over a network. In this workbook I added some data from a site that i wanted refreshed everytime the workbook is opened. I found out i can't protect the worksheet or protect and share the workbook and still have it refresh the data. Is there a way to protect/share the workbook (due to code inside the book) and still have the external web data refreshed upon the book opening

3/8/2010 8:28:01 PM 0 =?Utf-8?B?TXIuIG0wbGU=?= <Mrm...@discussions.microsoft.com>
Replace massively formulas with new formulas

Hi there, would like to get your input/hints on how to solve the following: In a series of cells in a row, I already have a formula calculating a division among two other columns. The rows are many (more than 500). But now I need to apply a ROUND formula, on top of the existing ones. ex. cell C5 = A1/B1 and I want to massively apply for all cells in a row the formula: =ROUND(A1/B1,3) I need the accuracy of the values to be at the 3rd decimal and not just the appearance of the cells. I also need to avoid VB programming. Anyone who can help? THanks M

3/8/2010 2:33:57 PM 4 mario <manima...@gmail.com>
How to replace ~ with other value ?

Hi Reader I have some cell have ~ in order number column, How to replace ~ to two -- ? Due vlookup can not handle ~. Moonhkt

3/8/2010 7:34:34 AM 2 moonhkt <moon...@gmail.com>
Print Dialogue Box

What is the macro command (code) to just open the Print dialogue box without printing? I tried this macro ExecuteExcel4Macro "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" but it printed the worksheet. Than kyou.

3/8/2010 5:20:48 AM 2 Salza <zainudd...@gmail.com>
calculating the number of pay-dates before a bill is due?

I'm trying to make up a budget for my family, and I'd like to have Excel tell me how much $ from each paydate I need to set aside, in order to meet my upcoming bills. So: 1. I'd like to be able to enter in the amount of an upcoming bill (a1), 2. the due-date of an upcoming bill (b1), 3. then somehow have Excel calculate how many pay-days I will get before that date (c1) 4. then I will use a formula =a1/c1 to tell me how much money I need to put aside from each of my upcoming paydays. Is this possible, to get such a formula for cell c1? I get paid on Friday morning, every

3/7/2010 11:50:03 AM 4 Judoman <yoko.gur...@gmail.com>
vlookup

How do I use vlookup if ret =abcd, dept = 999 and return value of no = 4 ? ret dept no abdf 123 1 abcd 234 2 defg 999 3 abcd 999 4 rgrg 456 5 wdff 547 6 abcd 888 7

3/7/2010 11:25:02 AM 2 "crapit" <...@mail.com>
Conditional formatting (Excel 2007)

I am using Excel 2007. I am trying to format time values that can range from seconds to years. If the time is below some threshold, say 1 day, I want to use the hh:mm:ss format. If it's larger that 1 day, I want to use the 0.00 format. After a little study, I selected this conditional format string: [<1]hh:mm:ss;[>=1]0.00 It seems to do the job. After some thought, it occurred to me that the second test might be unnecessary so I modified it to: [<1]hh:mm:ss;0.00 This also seems to work correctly. Is there any difference between these formats? Is one preferable?

3/6/2010 3:59:03 PM 2 Prof Wonmug <won...@e.mcc>
compute one of two missing value?

I want to create a table like this: column A is the name of the person column B is height in feet column C is height in meters How do I set it up so that if I enter a number in the feet column, excel would calculate and fill in the meter column, and if I fill in the meter column, excel would calculate and fill in the feet column?

3/6/2010 3:02:26 PM 1 "james" <nos...@nospam.com>
Copy to another excel file?

I need to copy info from an excel file to another using the files wich they are equal to a string provided by a column in a sheet. The names of the new files are the same of the column and the files are created fine, but the data fails. For each name in the column a file with name fnV&".xls" is created, i miss how filter the data from the range of data (A4:I32, for example), where the data to filter use the range A4:A32.

3/6/2010 1:30:26 PM 0 "gatolandia.chile" <gatolandia.clSINE...@gmail.com>
Excel 2007 How To Add New Number Formats to Styles

The Styles Functional Group in the Home Tab contains the following Style choices Custom Good Bad Neutral Data Model Titles and Headings Number Format When I created a new style it went into the Custom category but I'd like to move it to the Number Format choice. How can I add a new Style to a specific section of the Style functional group? Thanks for reading and for any help you provide. Regards (8^>)-]=[

3/6/2010 11:47:42 AM 0 "WSR" <wsr...@hughes.net>
converting numeric values into text in Excel 2007

Hi there, How to convert a numeric value into words in Excel 2007? For example, 4167 should read four thousand one hundred sixty seven.

3/6/2010 9:21:01 AM 1 =?Utf-8?B?QW1lcg==?= <a...@myway.com>
Conditional formatting

I am using Excel 2007. I am trying to format time values that can range from seconds to years. If the time is below some threshold, say 1 day, I want to use the hh:mm:ss format. If it's larger that 1 day, I want to use the 0.00 format. After a little study, I selected this conditional format string: [<1]hh:mm:ss;[>=1]0.00 It seems to do the job. After some thought, it occurred to me that the second test might be unnecessary so I modified it to: [<1]hh:mm:ss;0.00 This also seems to work correctly. Is there any difference between these formats? Is one preferable?

3/6/2010 6:41:26 AM 1 Prof Wonmug <won...@e.mcc>
Extracting Values from text embedded in cell

Thanks very much in advance for any solutions that can be offered. I have the following in cell A1: 123456-text 3" x 6 7/8" etc etc I have the following in cell A2: 654321-test 104 1/2" x 80 3/4" etc etc etc blah blah blah I would like to extract from A1 the value 3 and 6.875 into another location (ie. 3 in B1 and 6.875 in C1) I would like to extract from A2 the value 104.5 and 80.75 into another location (ie. 104.5 in B2 and 80.75 in C2) The length is always shown in inches (indicated as such by the single quotation symbol). The length could be a whole number of fractional as

3/5/2010 11:35:54 PM 10 Tony D <merritt1...@gmail.com>
Extracting Values from Text

Thanks very much in advance for any solutions that can be offered. What formula would I use to provide the following result: A B C 1 123456-text 3" x 6 7/8" etc etc 3 6.875 2 654321-test 104 1/2" x 80 3/4" etc etc 104.5 80.75 The length is always shown in inches (indicated as such the the single quotation symbol). The length could be a whole number of fractional. The spacing and position of the text above is exact (but length of characters may vary).

3/5/2010 11:21:53 PM 0 Tony D <merritt1...@gmail.com>
Need Help with a Formula

I need some help: In this example I have a column of 5 cells B1:B5. I also have another cell C1. I would like to have cell C1 to display the most recent entry in the B Column. Start B1=Null C1=Null B2=Null B3=Null B4=Null B5=Null First Entry B1=4 C1=4 B2=Null B3=Null B4=Null B5=Null Second Entry B1=4 C1=7 B2=7 B3=Null B4=Null B5=Null Third Entry B1=4 C1=3 B2=7 B3=3 B4=Null B5=Null Fourth Entry B1=4 C1=0 B2=7 B3=3 B4=0 B5=Null Fifth Entry B1=4 A1=9 B2=7 B3=3 B4=0 B5=9 Is there a fo

3/5/2010 11:04:49 PM 4 BerrSD <ber...@hotmail.com>
Printing to Day-Timer pages from Excel 2003

I have old printouts that indicate that in the past I printed from an older version of Excel to 3.75"x6.75" pages, but I don't see any way to do that using Excel 2003. How do I do that from Excel 2003?

3/5/2010 10:24:32 PM 1 =?Utf-8?B?RnJlZWxhbmNl?= <Freela...@discussions.microsoft.com>
validation for decimals

Hi there. I need to set a series of cells so that the user cannot enter anything other than 2 decimal currency values. Here's my code for this: ..Range("K" & sI & ":K" & sI).Validation.Add Type:=xlValidateDecimal, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0.00", Formula2:="999999999.99" It works but it still allows the user to enter more than 2 decimal places. There is no setting that I can find to limit the user so he/she cannot enter 3 or 4 or 5 or more decimal places. I know I can foramt the cells to only show 2 decimals but that's not really sufficient

3/5/2010 9:23:31 PM 4 Avian Rand <avian.r...@gmail.com>
Excel 2007 Ribbon - Remove unwanted custom toolbars

We had a series of engineering worksheets created in earlier versions of Excel that utilized custom toolbars created solely for the worksheets. they would be attached to the files which is how they were distributed to guys out in the field. Now that we are in the Office 2007 realm, our custom toolbars have been inserted into the Excel ribbon when our worksheets were opened. We have rewritten our engineering sheets to work with Excel 2007. Our problem is we cannot get rid of the many custom toolbars that have been populated on our Add Ins tab when Excel 2007 is opened on our machi

3/5/2010 7:35:01 PM 2 =?Utf-8?B?TXVzY29ieQ==?= <Musc...@discussions.microsoft.com>
Title Capitalization

Is there anyway to for a column to use Title Capitalization? --

3/5/2010 3:15:25 PM 2 "John Persico" <re...@newsgroup.com>
Printing Multiple Sheets

I know that I've done this in the past without any problems, but I'm using a new (to me) computer running Excel 2003, and am having trouble printing multiple sheets at the same time. I'm trying to select 2-3 tabs and printing them all as a group. The advantage is that page numbers in the footer reflect the group of sheets vs. each individual one. It's also very helpful when converting to PDF. The problem I'm having is that the 2nd page is not printing properly. The right column is being cutoff. I've checked the print range several times, and it's correct, and the sheet

3/5/2010 12:59:01 PM 0 =?Utf-8?B?VC4gSmVua2lucw==?= <TJenk...@discussions.microsoft.com>
File won't Calculate

I have a 35MB file that locks up when calculating. It's a process that has been use for several years; each year I do a "save as" to create the current year's evrsion. By year end, it can grow to ~65MB. I never had a calc problem before and it has worked fine all this year up to now. Any ideas? Thank you in advance, Mike

3/5/2010 12:44:01 PM 0 =?Utf-8?B?TWlrZSBUaGUgTmV3Yg==?= <MikeTheN...@discussions.microsoft.com>
Macros behave differnet when invoked by different methods

Using XL 2003, i have recorded several macros. For example, i recorded one that changes the "Move selection after Enter", to toggle the selection either Up or Right. I created an icon, using the letter "Z" to invoke it. When I click on the icon, the press Enter, the selection will move as required. But, if i use Alt Z to invoke the macro, then i have to press Enter 2 times. I have noticed this with other macros, that when invoked using Alt + letter, then an extra Enter is required. How can i eliminate the extra "Enter"? Thanks... Tonso

3/5/2010 12:31:42 PM 2 Tonso <wthoma...@hotmail.com>
Permanently setting the default comment font in Excel

{Using Office XP under Vista Home} How do I permanently set the default comment font in Excel? I want it to be Time New Roman 12. I've been through the Desktop > Appearance > Windows Classic > ToolTip thing (changed it to Times New Roman 12) and even found and used a macro that will change all existing comments in a spreadsheet to what I want: Sub FixComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments With cmt.Shape.TextFrame.Characters.Font .Name =3D "Times New Roman" .Size =3D 12 End With Next cmt End Sub

3/5/2010 5:22:30 AM 2 Opinicus <gez...@spamcop.net.which.is.not.invalid>
Engineering Economy and the Decision-Making Process (Joseph C. Hartman) solutions manual

I have solutions manuals for these scientific textbooks .. They are all in PDF format .. If you are interested in any one, simply send me an email to macmorino(at)gmail(dot)com .. Please this service is NOT free. Here are solutions manuals to some titles.. Instructor's solutions manual for A Course in Modern Mathematical Physics by Peter Szekeres Instructor's solutions manual for A First Course in Abstract Algebra (7th Ed., John B. Fraleigh) Instructor's solutions manual for A First Course in Differential Equations - The Classic Fifth Edition By Zill, Dennis G Instructor's solu

3/5/2010 3:04:13 AM 0 Mac Morino <macmor...@gmail.com>
Find the 10% value

Hi, I have a monthly report that contains data for a varying amount (each month) of users across several column. For each column I need to use conditional formatting to highlight the worst 10% for each measure. Currently I'm doing this manually by sorting the column ascending, then if there are 15000 users, look at the value corrensponding to line 1500, enter this in a cell which I then reference in my conditional format. What the best way to do this by formula? -- Rich http://www.rhodes-lindos.co.uk

3/4/2010 8:41:46 PM 2 "Rich" <REPLACEWITHr...@richdavies.com>
Excel Automation Question

I am trying to open an Excel spreadsheet in VB 2008 using automation. Once the spreadsheet is opened, I want to modify it, and force a recalculation. The auto calc function is disabled. I can opene the spreadsheet and modify it successfully. When I try to get it to recalculate, all the cells with formulas show this: #Name? Thanks for your help. My sample code follows: Imports Excel = Microsoft.Office.Interop.Excel Public Class frmExcel Dim objExcel As Excel.Application Dim objBook As Excel._Workbook Dim objBooks As Excel.Workbooks Dim objSheets As Exc

3/4/2010 6:49:05 PM 0 =?Utf-8?B?Q3Jhc2huYnVybjU1OTA=?= <Crashnburn5...@discussions.microsoft.com>
Formula with to Criteria

Hi, I have a row of numbers in Coloumn B ranging from 1 to 200 what I want is a formula in cell A1 that will do the folowing. Look at my range in coloumn b for example B1:B200 and countif the number is the coloumn is over 25 >25 and below 100 <100. I can do countif functions but don't know who to do the above or below part. Any help would be apperciated Thanks

3/4/2010 5:45:01 PM 2 =?Utf-8?B?R2xlbm4=?= <Gl...@discussions.microsoft.com>
Balancing

Hi I have a excel data range from that I have to create a daily balance register Say' in row 1 op value, row2 to row10 contains transcation details, I want a new row to be inserted in the end of the row (end of the each date) and the value of row1 & row2 to row10 to be combined in the inserted row any help ? Thanks Raj

3/4/2010 5:14:07 PM 1 "Boopathi" <boopath...@hotmail.com>
excel for analysis

Hi, Please how may i use excel for analysis as in SPSS package.Otherwise which package works best for statistical analysis.

3/4/2010 2:46:52 PM 0 ARTERIES4U <olanrewaju.has...@gmail.com>
excel for analysis

Hi, Please how may i use excel for analysis as in SPSS package.Otherwise which package works best for statistical analysis.

3/4/2010 2:46:43 PM 1 ARTERIES4U <olanrewaju.has...@gmail.com>
VBA problem

I would like a macro to run only if the active cell is in a specific column. I have tried: If ActiveCell.Column="X" Then run macro etc End If But this does not work. I think the syntax above is incorrect. Would appreciate help in correcting this. JP

3/4/2010 9:36:06 AM 2 "JP" <D...@nomail.com>
Indirect function call?

Suppose I have an array of sines with arguments such as =SIN(j*B3) where j is aninteger or another number. That is, the array has arguments conisting of a product of numbers multiplied by contents of a cell, for example. Is there a way to have a cell containing "SIN" or the like to provide the argument function. Thus,if I were to have COS or EXP in that cell my array would evaluate terms like =COS(j*B3) or =EXP(j*B3). I know I can do this if I have a separate array just for the arguments and use a similar size array for the results. I also know that I can copy and past o

3/4/2010 2:00:32 AM 3 Salmon Egg <Salmon...@sbcglobal.net>
Macro to find spaces?

Hello. Hello! My spreadsheet error-checking macro didn't pass the test today. Here's the situation: There are several cells in the range where I tell the user to leave them blank if they do not apply. So for the formulas for these, I can just use If(d2=""...). But if the user hits the space bar, then the cell is no longer blank, even though it looks like it is. So, the macro needs to check the range of cells (D2:D34). If any of the cells have only spaces and no other characters, then end the macro and put up a message box that says "The following cells are not blank: d3,

3/4/2010 12:06:23 AM 6 Lostguy <cpo...@mail.com>
docking menus to capture picture for instructions

I need to dock the pull down menus (ex: Tools) in the open position so I can use PrintKey to capture only the menu selection (not the entire screen) for added to instruction documents. Any help would be greatly appreciated!!! Thanks in advance!

3/3/2010 8:35:03 PM 0 =?Utf-8?B?bGxkaWVs?= <lld...@discussions.microsoft.com>
Create a chart with data range not related to any specified worksheet.

Hi All, I have a question how can I create a chart with a data range that will not refer to any particular worksheet. So I can record macro when inserting and configuring a chart, and then repeat it on another worksheet by simply running the macro. Currently I must record and manually edit the macro to remove all references to "Sheet!" in ranges. Is that possible? The point is to teach a non-technical person to work better by recording and running macros... I'm using office 2003 but solution for Office 2007 will be great! Thanks, Gborek

3/3/2010 7:57:09 PM 2 dobrzanski <sdobrzan...@googlemail.com>
Return 0 After Milestone is Reached

All, I am using this formula to calculate monthly taxes, which are based on a % of income. Once you've paid a certain amount of tax, you don't have to pay any more. I'm using this formula - which sucessfully works up to and including the month where you pay less than the average month. I now need to take it a step further, and say once the maxtax has been reached, return a 0. A4 to L4 are my monthly income amounts. =IF(SUM($A4:L4)*tax<MaxTax,L4*tax,(SUM($A4:L4)*tax)-MaxTax) Any suggestions? Thanks, Patrick

3/3/2010 7:47:21 PM 3 Patrick A <park...@stradley.com>
Excel creating tmp files

I have office 2007 installed on my new PC which has windows 7 and when I make a change to an excel file it wants to create a separate file labled with a tmp extension ie f5de4221.tmp. Why is it doing this and what can I do to stop it. Jim S

3/3/2010 3:43:46 PM 0 "Big Jim" <jimnos...@qwest.net>
Position a chart according to the position of the userform

Dear all, In VBA, I am trying to move a chart according to the position of a userform. How do I calculate the x and y position of the chart so that it will be aligned with the position of the userform. Thank you Gaetan

3/3/2010 3:15:21 PM 2 Gaetan <gmourm...@gmail.com>
generate list of non-entries within dates

I use Excel (2007) to record activity and support for about 100 current online learners and I have to provide an activity summary sheet every two weeks. The list of learners is in one sheet and are marked "current", agreed break" or "completed" in an adjacent column. The total list is about 1000 and grows by about 10 each week. The activity log is another sheet of the same workbook. Assuming that all activity is logged in this way I need to generate a list (sheet) of those current learners who have not submitted any recent work and are therefore "inactive" within the two week period

3/3/2010 1:23:31 PM 3 david_g <da...@gts.co.uk>
Excel crashes

I got a user with Excel issues. Every time she tries to create/open an existing workbook , the program crashes. I've tried the following things to make it work but with no results: Uninstall/reinstall Office Uninstall proof and interop HKEY_CURRENT_USER\Software\Microsoft\Office changed that directory into HKEY_CURRENT_USER\Software\Microsoft\old_office and then reinstall. "AppName: excel.exe AppVer: 11.0.8033.0 AppStamp:449c383b ModName: msvcrt.dll ModVer: 7.0.2600.2180 ModStamp:41109752 fDebug: 0 Offset: 00037efb" BR Blacker

3/3/2010 11:00:01 AM 0 =?Utf-8?B?QmxhY2tlcg==?= <Blac...@discussions.microsoft.com>
can't open a scrap excel file,

Hi all! My teacher geve me a file wich is very important. When i saw it on my teacher's computer, it's excel scrap file, and no problem for opening. But on my computer it can't be opened. When i double click it, it says that "file format is unvalid" but i try it on my friend's computer it can open. It's very important and hurry for me. PLEASE HELP MEE I have excel 2007 and using vista, is this the problem?? Thanks, url:http://www.ureader.com/gp/1027-1.aspx

3/3/2010 9:27:28 AM 2 "uyanga"<ganaashkinaas...@yahoo.com>
Macro to change pivot field

This is a re-post as my questions hasn't been answered by anyone... Hi there and thank you in advance for any help. I have written a macro that changes (hides / shows) fields on a pivot table. One of these changes the field used for the page fields section of the pivot table. However, when i add a field to this section, it defaults to All. How can have this field default to the latest value in this field. Let me explain further: I want the pivot to be shown either by date or by week. The macro then changes the page field section to show either the date or week field. If the

3/3/2010 8:11:01 AM 0 =?Utf-8?B?UHN5YmVyRm94?= <Psyber...@discussions.microsoft.com>
Pivot Chart - negative values not displaying properly

Hello, I am trying to create a stacked area Pivot Chart from a Pivot Table. I have negative values but am having trouble getting them to be displayed properly in the pivot chart. Currently, the negative values are displayed at the top and are "eating into" the positive series. I need the negative values to be displayed below the x-axis. Any help would be greatly appreciated.

3/3/2010 4:32:30 AM 2 Aleksandr <afey...@gmail.com>
Data Validation dropdown list - don't want doubles in list

Hello, I am using excel 2007 and am creating a drop down list by selecting "Data Validation" and entering a column I have with different names in it that are repeated over again in no particular order. I need the list to only contain each name once to select from though. Is there any easy way to do this? Thanks, Ben

3/2/2010 6:37:03 PM 2 Ben <...@efg.com>
lookup from a table in a pivottable

Hi (excel 2007) I have a regular table (Table13) with some productinformations. I column M i have the SerialId for the specific item. I need to check if the SerialId already is in our ERP-system (ax). I have a pivottable showing all SerialId's from my Ax-table. Excel has given the pivttable the name Pivottable1. I now want to write a formular like =VLOOKUP(Table13[[#This row];[SerialID]];pivottabel1;1;True) But it seems not to be possible to lookup into a pivottable ??? Regards Peter

3/2/2010 1:12:38 PM 4 Peter <pgrandj...@jubiimail.dk>
refer to same row in other columns by using entire column in formula

Context I have lots of columns of data which I want to do calculations on, and i always want to consider the same row only. I would like to use names in the formulas to make it easier to keep track of which columns are being used. So it's not as if I have a problem at the moment, just that it could be easier to follow if i used named ranges. Now, I noticed a 'feature' of excel and was wondering if it is safe to use. Here it is: Column A has, say, row numbers in it, so A1 has a 1, A2 a 2, etc. If in cell B1 I type: '=A:A', the result is 1. Below is cell the formula is typed i

3/2/2010 12:40:32 PM 2 brzak <brz...@gmail.com>
File-list generated from folder including attributes

Hey guys My macro generates a file-name list with accordingly attributes as "size", "Accessed date". My problem is to expand this Explorer-information with attributes: "Author" and "Owner". I dont know/cantv find the code...... maybe file.author or something????+ Here is my macro: Sub SelectFiles(ByVal sPath) '----------------------------------------------------------------------- Dim fldr As Object Dim Folder As Object Dim file As Object Dim Files As Object Set Folder = FSO.GetFolder(sPath) Set Files = Folder.Files For Each file In Files If (fi

3/2/2010 9:41:30 AM 3 Snoopy <blak...@jjuc.no>
Villes fran�aises...

Bonjour � tous, Qui aurait en magasin la liste des villes fran�aises de + de 10 000 habitants (avec le code postal) ? Note : Tout format de fichier (Excel, Texte, Etc.) convient. Si certains sont int�ress�s, j'ai la liste de toutes les communes fran�aises � dispo. (fichier .mdb) D'avance merci, jpg

3/2/2010 6:48:13 AM 3 "jero" <~j...@jero.net>
Excel spreadsheet to web page issues

I don't know if this the right place to inquire.. but for a lack of any other places... I have a multi sheet spreadsheet (Excel 2003) that I have saved as an htm file and posted it on my web site. I am pleased with the results except for two issues that I would like to tweak. 1. The sheet that had focus when I Saved as Web Page is the right size, the other sheets are much too wide (~2000 px). How can I control this? There are only some 5 odd columns however a print preview shows two pages wide. 2. Because there are multiple sheets I have a row of tabs at the bottom of my page,

3/2/2010 5:36:30 AM 0 Ralph2 <nonefo...@hotmail.com>
Excel compatibiliy with newer version

I have Office 2000 and I understand there is a patch you can download where you can open files from newer versions of Excel. I can't seem to find anything like that on the MSOffice downloads. Can anyone point me in the right direction? Thanks and God Bless!! -- Sabrena Vick

3/2/2010 2:50:01 AM 1 =?Utf-8?B?c2Fidmljaw==?= <soonerben...@yahoo.com>
Chart blanks

Hi I have a chart with 2 lines on it. One has 52 data points and is last year's data. This year's line has, say, only 20 points. I would like this years line just to stop after the 20 points but it continues showing 0 for the rest of year. How do I get it just to not plot! Thanks Max

3/1/2010 8:42:21 PM 3 "Max Scott" <...@maxwells.co.uk>
Jump within IF statement?

I'm not sure if I can type my example here since its a diagram, so I'll try to explain generally what I'm trying to do. I made a tree diagram starting at the top with a question, which then branches into two branches for yes or no - IF(question here,yes action,no action). Now the tricky part is, I've gotten to a "no" branch where the action is the same as a "no" branch that is further up the diagram. Is it possible to tell the function to "jump" to another section within the same formula?

3/1/2010 6:38:08 PM 1 MLT <mlthorn...@gmail.com>
Export to XML

I am using the Excel: Export to XML feature, but there are some issues I need to resolve. I am providing a schema (from InfoPath) for the mapping. 1. The default namespace "my" is getting renamed to "ns1". 2. Fields I don't map (or even if I map them to a blank column) are not getting exported as part of the XML. If I use the InfoPath template.xml file as a starting point instead of the schema, I also run into the issue that: 1. The processing-instructions are getting stripped out. Is there any way to resolve any of the above?

3/1/2010 5:52:39 PM 0 "Greg Collins" <gcollins_at_msn_dot_com>
list macro or module on sheet

Hi all i have a workbook which runs lots of vba macros - what i would ideally like to do is to list on a new sheet the macros that i have run since opening the file. is there some code to do this. obviously i could put something into each macro to write its name somewhere, however i would like if possibel something more efficient than this? regards Simon

3/1/2010 1:50:06 PM 0 crossy75 <sjc5...@yahoo.co.uk>
Pivot: totals in the next column

Hi all, i need your help for the below table: ITEMS YEAR YRLY_TOT GRAND_TOT 2008 $10 1. ITEM1 2009 $20 $60 2010 $30 2008 $10 2. ITEM2 2009 $30 $80 2010 $40 2008 $20 3. ITEM3 2009 $30 $90 2010 $40 Each item has yearly totals (column YRLY_TOT). I want column GRAND_TOT to show total of all three years for each item ( i guess the three cells shou

3/1/2010 11:14:01 AM 3 =?Utf-8?B?R2xhZGlhdG9y?= <Gladia...@discussions.microsoft.com>
using sumproduct with a substring condition?

I have a calculation I just made that looks like this: =SUMPRODUCT(--(C5:C50="persons name"),I5:I50) which works out the hours billed from column I and works fine. Column E has a description in it which sometimes has at the end of the description the words "do not bill." Is there any way to add this condition to the sumproduct - i.e. exclude from the sumproduct any value in column I that has the "do not bill" sub-text in column e? Thanks, Ben

3/1/2010 3:47:01 AM 3 Ben <...@efg.com>
Allow duplicate "NA"'s but no other dupes?

Hello! D24 through D26 contain FYs for a school. If the school duration goes into the next FY, you pick that from the dropdown. If it continues into a 3rd FY, you pick that. There is also an "NA" So for most short schools, D24 = "2010", D25="NA", and D26 ="NA" Longer schools will have D24 = "2010", D25="2011", and D26 ="NA", etc. For error-checking, two "2010"s would be bad and redundant. So I pop up a messagebox for that. But it is also counting two "NA"s as bad when that is OK. So, it should be msgbox if they are the same FY except if they are NA which is OK. How can I fix t

2/28/2010 11:09:32 PM 3 Lostguy <cpo...@mail.com>
getting excel to give me a 'time to leave' time.

You would think this fairly simple. I want to be able to plug in a 1)start time, a 2)lunch out time, 3) a lunch return time, and then have exel tell me the the time to leave for an 8hr day. The problem comes in trying to subtract the morning hours worked + lunch from a constant, the 8. If I can get that to work, then it should be fairly easy to add that onto the lunch return time to get a clock out time.

2/28/2010 4:01:16 PM 2 Kyle Hogan <kyleho...@msn.com>
Different Instances of Excel

My excel nows opens in different windows. Previously if I had excel open and clicked another .xls (or .xlsm) file in explorer it would open that file in the excel window already open. Similarly if I opened an .xls attachment in a email directly from outlook it would open the files in the existing window. Now, for some reason, it creates a new instance of excel, a new window. How can I get back to the original behaviour? Thanks Max

2/28/2010 8:43:13 AM 3 "Max Scott" <n...@microsoft.com>
Find (Ctrl-F) won't find "~"

The Find function (Ctrl-F) won't locate occurences of the "~" character. Is there some way I can search for that character?

2/28/2010 1:39:17 AM 3 Prof Wonmug <won...@e.mcc>
Export Excel (2007) data "as is" with arbitrary delimiter

I have a large Excel 2007 file containing text data that includes most of the special characters on the keyboard. I need to create a delimited text file without any processing of the data. That is, no adding quotes or what have you. I have tried the csv and tab-delimited text options. They all mess up if there are commas or quotes. I couple of websites say to accomplish this by changing the List Separator to "|" or something. http://astrochimp.com/2005/12/20/export-csv-with-any-delimiter/ This works better than woth a comma, but Excel still searches for quotes and encloses t

2/28/2010 1:32:59 AM 1 Prof Wonmug <won...@e.mcc>
Ctrl+v doesn't work correctly

I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and paste using Ctrl+V, only the copied value (i.e., not the calculated value using the formula) is pasted. When I copy using Ctrl+C and paste using a right mouse click, it pastes correctly. Also, if I copy using Ctrl+C and drag to the cells I want to calculate, it pastes correctly. If I copy using Ctrl+C in cell C1 (having divided A1 by B1) and then select cells C2-C3 and try to paste using Ctrl+V, I get a message that the data on the clipboard is not the same size and shape as the selected area, do you want to paste t

2/28/2010 12:07:40 AM 0 Bob <bob.is...@comcast.net>
test

Hi Terry

2/27/2010 9:33:17 PM 0 "Terry" <terrybetts11...@hotmail.com>
Excel solver

I cannot distinguish between the "precision" and "convergence" setting in the Solver. Anybody know about them. They seem to represent the same thing. Just increasing the "precision" seems OK. Thanks

2/27/2010 3:24:31 PM 5 "Carlson" <davidcarl...@yahoo.com>
Copy worksheet from one book to open workbook

Hi there I hope you can help. I want to copy a worksheet from one book to the workbook that is already open. Example - open closed book called Owner Rep and copy the single sheet in that book called sheet1 to the open book and replace existing sheet1. thanks Nev

2/27/2010 1:09:01 PM 1 =?Utf-8?B?TmV2?= <...@discussions.microsoft.com>
Help with Vlookup Function

Hey there. I'm working with two sheets on a file. On the first sheet is a list of students and the schools that they attend, with the student in column A and the school in B. There are 200 rows. In sheet2, there is a list of the schools and a countif for the number of students at each. There are six students at School Alpha. I want to perform a lookup that returns the names of each of those six students, as listed in column A of sheet1. Any ideas? I'd appreciate it if anyone had any advice. If you need clarification, don't hesitate to ask. Thanks in advance.

2/27/2010 5:19:09 AM 9 David Nolan <legoriien...@gmail.com>
summarize open issues

i have 3 different open issues lists on 3 tabs of a workbook that i want to summarize the priority items onto one list on another tab. i want to tick off items in priority order by a,b,c etc. and collect them in sorted priority order all on one tab. does anyone have any ideas how i can do this? i appreciate any help you can provide. thank you

2/27/2010 4:28:01 AM 1 =?Utf-8?B?am9obg==?= <j...@discussions.microsoft.com>
sorting protected sheet not working

I'm getting the impression from my tests and reading various forums that this is not possible even though the protection dialog box has an option to allow sorting. I'm creating a spreadsheet on the fly from MS Access vba based on some SQL data. This is distributed to another company so they can fill in some of the missing data. There are 10 columns. The first 8 are for reference only and are not to be edited. The last 2 columns are the ones they can fill in if needed. So I'm protecting the sheet and unlocking the last 2 columns. All that works peachy but even when I say to all

2/27/2010 4:12:16 AM 6 "Keith G Hicks" <...@comcast.net>
Add and subract Time

I found a time card worksheet on-line and I don't understand the formula. It works but even when I evaluate the formula I don't understand why. D E F G Start Wrk Start Lun End Lun End Wrk 8:00 AM 11:00 AM 1:00 PM 5:00 PM The row with the times is 8. the formula in cell H8 is =(E8<D8)+E8-D8+(G8<F8)+G8-F8 I don't understand what the (E8<D8) or (G8<F8) does? When I evaluate the formula they both return FALSE. If I change the time so the evaluate as TRUE it still does the math. In fact I can take it out so the formula reads E8-D

2/26/2010 8:12:02 PM 1 "DG" <noth...@somewhere.com>
Can't Run Macros; Blocked By Security

My hard drive crashed, and I had to re-install Office 2007. I open Excel, and try to open .xlsm workbook I'd created previously. when it opens, I have under the ribbon: Security Warning Macros have been disabled. So I click the Options button, and I get: "Security Alert This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them. To run these macros, remove the encryption or permission restrictions on the file." The only option I'm offered in this popup box is "Help protect me from unkown content (recommended

2/26/2010 6:27:40 PM 3 RandomStu <random...@gmail.com>
How to make a 'comment' transparent

Any way to format 'comment' transparency (default = opaque) ? -- Thanks again for your help. akm (XPpro,SP-2,IE-7,Office2003)

2/26/2010 6:16:04 PM 2 =?Utf-8?B?YWtt?= <...@discussions.microsoft.com>
Excel 2007 Macro shortcut key doesn't work but menu selection does

I have a very short set of Macro's one of my users has recorded. All of them worked at first but now one of them will not function via the shortcut key. It will function if you select and run it by using alt-f8, clicking on it then run. Out of curiosity I reinstalled office, same problem. Then I even gave him a new PC to play with. He recorded the macros and they ran fine for many days then the same problem recurred. Any thoughts? Thanks,

2/26/2010 5:49:01 PM 1 =?Utf-8?B?TWFsZmFuZQ==?= <Malf...@discussions.microsoft.com>
A single location for all my Macros

Good morning, I'm wondering if there is a way to get all of the macros that I have scattered across a bunch of files in a single locations, like Personal.xls? Some macros are used very infrequently and if I had them all in one location, I wouldn't have to spend the day looking for them. Related to this, is there a simple way to locate all of the macros you may have hidden in your various workbooks? As always, your time is greatly appreicated. Mike, Athens, Ohio, USA

2/26/2010 3:15:58 PM 3 Takeadoe <mtonkov...@msn.com>
running macros

Hello, I have an excel file that it is opened every time I open excel (let=92s call it PERSONAL.xls). In it, I keep many macros that I frequently use. I still have to learn how to have the macros in this file operate in any other file that I open. For example I have this macro in the PERSONAL.xls. It supposed to create a link form the text in the cell (The file is a collection of search results). Sub Insert_Link() For I =3D 1 To 1000 R$ =3D Str$(I) a$ =3D Cells(2, R$).Value Sheet1.Range(a$).Select ActiveSheet.Hyperlinks.Add Anchor:=3DSelection, Address:=3Da$, TextToDis

2/26/2010 1:47:53 PM 2 tuli <tuli.herscov...@gmail.com>
system can not find the file specified

Suddenly for 1 user on an xp workstation, whenever she tries to open excel 2003 she gets the above message. when I login I am able to open excel. 2003 with my account. what would cause this and how to fix thank you carlo

2/26/2010 1:49:39 AM 1 "News" <...@no.com>
selecting different columns

I want to do a select case that picks a specific column based on another, independent variable. Something like: select case colno case1 if a=1 then colno="C" (Select column C) if a=2 then colno="M", etc. Then I want to do a range select, such as range(2,colno).select, or range("colno,2").select, or something similar. I have tried all the combinations and quotes I can think of but no luck. Is there a correct format to use something other than range("C2").select to select that cell? TIA Bill Roberts -- Bill Roberts

2/25/2010 10:53:01 PM 2 =?Utf-8?B?QmlsbCBSb2JlcnRz?= <BillRobe...@discussions.microsoft.com>
selecting different columns

-- Bill Roberts

2/25/2010 10:44:01 PM 0 =?Utf-8?B?QmlsbCBSb2JlcnRz?= <BillRobe...@discussions.microsoft.com>
Search and find test

I want to find all cells that contain whatever text I am searching for. Ctrl+F will do this and display everything it finds in a separate window. What I would like to do is have all of the cells and contents in the row displayed that the search finds. ..

2/25/2010 9:12:29 PM 1 BF <B...@adelphia.net>
Querying Excel tables from Microsoft Query

Apologies if this posts twice. Since my posting hasn't shown up in 5 hours, I'm assuming it got lost. I cannot query a Microsoft Excel workbook with Microsoft Query. The error message I get is "the data source contains no visible tables". But the workbook that I am trying to query contains two named tables. Any suggestions on what the problem might be? Thanks.

2/25/2010 6:46:01 PM 1 =?Utf-8?B?SkdQYXRyaWNr?= <JGPatr...@discussions.microsoft.com>
Sub Totals as a calculated field in a pivot table

I have a pivot table that pulls revenues product line and displays in monthly columns. Can I create a subtotal that displays quarterly data as a calculated field? In another pivot table I have revenues and costs associated with a variety of projects. Is there a way to subtotal the costs separately from revenues? Thanks for reading.

2/25/2010 4:11:02 PM 2 =?Utf-8?B?Q2hlc2ls?= <Che...@discussions.microsoft.com>
Evaluating 3 Excel Sheets

Hi newsgroup I have a excel file which has 3 sheets. This 3 sheets are feeded with data of a database. In the first Sheet i have data from a table 'questions'. This table has a ID. in the second sheet i have data from a table 'candidate'. This table has an id too. in the third sheet i have data from a table 'anwers'. this table has an id and has also the id of questions and candidate. Now I like to create another sheet in excel, which shows me the third sheet combined with sheet1 and sheet2. The relationship is given by the ids. Has anyone an idea how to do this? I th

2/25/2010 2:41:36 PM 1 "Ueli Werner" <mus...@hotmail.com>
Transfer of list of dates and events to a calendar format

I want way to transfer data from a list of dates in column A and events in column B. Given a monthly calendar such as commonly used, I would like to transfer the text of events in column B to the appropriate box in the calendar. Is there an easy way to do that? One way that would do the job is to make monthly calendar pages by using Excel resources. That should be platform independent. Om my case, I use a Macintosh that already has a calendar application called iCal available. I have no idea, however, on how to carry out that task simply. Please suggest a simnple way of do

2/25/2010 4:51:47 AM 3 Salmon Egg <Salmon...@sbcglobal.net>
Calculation & Negative Help

Hi All, Please can someone check my maths below & calculations as it doesnt look right! Im looking in particular at the -100.00 The idea of this little table, shows how much debit & credit you have had, and against a target, with a variance % it should be that a negative number is bad, positive good. In the example shown, there is an allowed / target deficate of -350 between the deb & credit. the actual shows that debit was not as much as thought, being good, and cred being 200 better. The TOT dff row then works out differences, I would have expected the -100.

2/24/2010 9:10:54 PM 2 "Jack Rabbitt" <...@b.com>

Pages: 2 3 4 5 6 7 8 9 10











Newest Articles

Can I read a range of scenario (input) values from a table?
5 min. 10 sec. ago

Wireless Conundrum
10 min. 43 sec. ago

Search Function in Discussion Groups Home
12 min. 10 sec. ago

Link Items in Same Table
12 min. 41 sec. ago

Printing With XxcelViewer
13 min. 10 sec. ago