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 ...
|
