Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
group : microsoft.public.excel      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



Pivot Table in Excel not reading Access Query     Wed, 5 May 2010 11:55:30 -0500
I use Access link to a SQL server database and then run queries in Access. I wanted to do a Pivot Table in Excel because of other users able in the office. I can't get Excel to import or even show one of the queries in Access where I use MonthName to get the month's name and not a number. If I use the month' ...

Re: SUMPRODUCT using Time between two values     Wed, 5 May 2010 08:56:36 -0700 (PDT)
On Apr 27, 2:19 am, David Heaton <dhea...@stanleyworks.com.au> wrote: > On Apr 24, 1:15 am, Finny <conorfinne...@gmail.com> wrote: > > > > > Thanks in advance for any help you can provide me.  I have a sheet > > with the following layout of data (shortened here and changed for > > obvious reasons) > > > Ven ...

Cut and paste from web pages, emails, is breaking up text into multiple Excel cells     Wed, 05 May 2010 11:03:46 -0400
Up until a couple of days ago. I have been copying my online checking, mortgage, credit card, and other online tabular data into a spreadsheet with no problem. All numbers, dates, times, dollar amounts, and text phrases were pasting into my spreadsheet cells correctly; one spreadsheet cell for each web page ...

Problem mysql import in powerPivot for Excel 2010     Tue, 4 May 2010 08:32:37 -0700
Hello I get an error when I attempt recovery of tables in a mySql database via the import wizard powerPivot for Excel 2010 "Failed to retrieve data from absence. Reason: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-4.1.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds ...

How to Pull Outlook contact info into Excel     Tue, 4 May 2010 08:12:43 -0700 (PDT)
Hey Group, I've got a spreadsheet that lists a bunch of contacts. They same contacts reside in Outlook. In the past I've always retyped the contact info into the spreadsheet. Is there a way that it can automatically pull this information? Or a script button I can click on to get the info? I've done some s ...

SUMPRODUCT Date Ranges     Tue, 4 May 2010 06:06:57 -0700 (PDT)
Hi, I need to note a '0' or '1' within each of the monthly cells in a table to show resource secured within a given month (the date ranging from the start and finish date). So, if the START date is A1 and the END date is B1 and I have a cell for each month, i.e. C1 = Jan, D1 = Feb and so on till Dec. As ...

How to count cells with conditional formatting     Tue, 4 May 2010 05:37:17 -0700 (PDT)
Hi! I´ve used conditional formatting to color the cell from each column that has de top value. I´m using Excel 2007 and I´ve created a rule from the category Format only top or bottom ranked values. I´ve set it to Top and instead of 10, I´ve put 1. This works fine. What I need to do is to count by row how man ...

Pivot Table Help - Gross Margin % & % of Sales     Mon, 3 May 2010 18:48:15 -0700 (PDT)
Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working with: https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ I'm having problems with showing percentages in my pivot table such as gross margin and operational profit. Here is the P& ...

Regression     Mon, 3 May 2010 13:22:01 -0700
Would someone be able to provide the steps to use the Regression formula and some understanding of the information it provides?I'm interested in using it as a forecasting tool. Thanks in advance. ...

Help with formula for Microsoft excel     Mon, 3 May 2010 08:40:33 -0700
Hello, I am currently having some problems in getting a formula to work the way I want it to. Lets say in column a row a1 I have 716+70. In column a row a2 I would like 716+80 and in column a row a3 I want 716+90 etc for the remaining. What I would like is that it constantly add 10 to each row. Can someone help ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us