|
EDIT:
I'm told that making you guys read means I get less attention. My apologies. Here's a simpler version:
Bill got $100 dollars worth of items from a store.
He wants to return enough of the items to get exactly $30 dollars back.
The store has a Point...
Started by Anthony on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SELECT.
If this is not satisfactory, then maybe SQL is not the right tool for this job.
Is as follows.
|
|
I have the attached spreadsheet as a sample of what I am trying to update/recreate. The spreadsheet is created via VBA in an Access tool. Data is first exported (first tab), then subtotaled and aesthetic changes made (second tab). Works great using the...
Started by kwvh on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at eileenslounge):
And then I search for the subtotals formula in the cells as a landmark for inserting blank rows.
|
|
On Thu, 20 Aug 2009 16:31:35 GMT, "TraciAnn via AccessMonster.com" <u50702@uwe
I need to export data to excel and include subtotals.
The query selects EmployeeName, StartDateTime, EndDateTime and DurationHours
and filters on StartDateTime (Between...
Started by TraciAnn via AccessMonster.com on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Why? You really don't need to answer this question; but there's a very... .
On Thu, 20 Aug 2009 16:21:30 -0500, "Clif McIrvin" <clare.moe@nevergmail.com.invalid
Hi TraciAnn -
"TraciAnn via AccessMonster.com" <u50702@uwenews:9ae2de43cab3d@uwe.. .
|
Ask your Facebook Friends
|
Hi,
I'm struggling with charts in Excel.
My data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5
Every day I add a column with extra data (the output of a sql statement).
A chart with 4 series (...
Started by jan on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at superuser):
DB Extra is also another tool.
An eval copy out there to see if it really does what you need it to do .
|
|
On Mon, 2 Feb 2009 09:03:01 -0800, Quana <Quana@discussions.microsoft.com
I am using 1997-2003 version of Excel
When using the subtotal on a spreadsheet and when the subtotals are shown,
the spreadsheet does not list the groupings on it. The ...
Started by Quana on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
On Mon, 02 Feb 2009 11:50:21 -0600, Dave Peterson <petersod@verizonXSPAM.net
Maybe you're not showing the outlining symbols:
In xl2003 menus:
tools|Options|view|check "Outline Symbols"
--
Dave Peterson
Hi all,
VLOOKUP(lookup_value....
|
|
On Wed, 28 Jan 2009 12:50:05 -0800, pjryan <pjryan@discussions.microsoft.com
I am working on a spreadsheet that was developed by someone else. There are
several data columns followed by 12 monthly columns containing numerical data
for each month...
Started by pjryan on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
What version of Excel are you using?
--
If this helps, please click the Yes... .
On Wed, 28 Jan 2009 13:40:01 -0800, Shane Devenshire <ShaneDevenshire@discussions.microsoft.com
Hi,
Check to see if Tools, Options, Calculation is set to Manual.
|
|
On Thu, 6 Nov 2008 10:25:03 -0800, Abe <Abe@discussions.microsoft.com
In Excel 2007 how do I subtotal and outline automatically like I used to do
in 2003?
Started by Abe on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
How do I do
this in 2007? It seems that 2007 removed a useful tool or at the very least
made it difficult to accomplish.
That if I
collapsed the outline, I see only the rows with the subtotals.
|
|
On Fri, 26 Dec 2008 14:52:22 -0800, Square Peg <SquarePeg@Round.Hole
I need something that is half way between Word and Access. I'm
wondering if Excel can fill the bill.
For tome to time, I have a need to keep track of "events" and
calculate subtotals...
Started by Square Peg on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
On Fri, 26 Dec 2008 17:10:10 -0600, "Don Guillett" <dguillett1@austin.rr.com
=sumproduct((year(a2:a22)=2008)*b2:b22)
=sumproduct((c2:c22="United Way")*,b2:b22)
=sumproduct((year(a2:22)=2008*(c2:c22="United Way")*b2:b22)
--
Don Guillett
Microsoft... .
|
|
On Mon, 22 Jun 2009 16:30:01 -0700, Paula <Paula@discussions.microsoft.com
I am tryiing to sub total in SLB. After each of the lines i am trying
print a subtotal for all the details for the lines, for example subtotals for
item ABC.
Is there...
Started by Paula on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Com
Paula,
It will be easier to get the ....
If all you want are the subtotals (no detail), you can create a summary
smartlist .
Detail, with subtotals, you will need to export your data to
excel and subtotal with formatting.
|
|
One of the most frequent requests i get is to create XY report for YZ App. This apps are normally built on php, so far i have manually created most of this reports, and while I enjoy the freedom of building it like i want, it usually becomes pretty tedious...
Started by rcphq on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
A little Google search gave me the following OSS:
RLib
http://rlib.sicompos....
You could install google analytics and the client could export whatever format they wanted .
Site stats...
For example...
It depends on what kind of reports you're talking about .
|