All Questions
72
questions
4
votes
1
answer
2k
views
Auto formatting new pivot rows to data bars
I have a pivot table that takes data from database and displays it as a data bars. Problem is, that the data is updated daily - every day new row is added so the pivot table is growing. Unfortunately ...
-3
votes
1
answer
306
views
Excel - sumproduct/sumif
I am able to look up single values that meet multiple criterion; but I would like to do more, I want to sum up values that meet two conditions - year and country like in my example. I tried it in my ...
1
vote
1
answer
68
views
How can I summarize cells based on date in other cell?
I have one Excel sheet with columns "project name", "project date", and "effort estimation".
On a second sheet I want to summarize those projects according to the months of the year.
So I have ...
1
vote
0
answers
242
views
Using getpivot in excel to create flexible reports based on user inputs
I am trying to make a report in Excel that sits on a very large set of data (set up in proper pivot form). I want to be able to select a value for a few fields (or select a value from 1 field but ...
1
vote
1
answer
4k
views
PivotTable -- how to sum the result of a countif formula by group?
Current Setup
A table (Table1) that has the following fields:
Organization Name
Person Name
Several fields that users can put an "X" into (each represents a "module" that users would need access to)
...
0
votes
1
answer
487
views
Creating Crosstabs in Excel
I have a survey asking about mobile device usage, but people have the option of checking more than one device...so folks may check iPad and Android phone, or folks can only check iPhone, etc.
I am ...
4
votes
2
answers
1k
views
Counting "0" Stock Values Generated by Pivot Table
I have an inventory ledger. It looks like this:
Tran Type Txn Date Item Quantity
Opening Balance 6/30/12 Item1 4
Opening Balance 6/30/12 Item2 7
Shipping ...
1
vote
3
answers
2k
views
How to easily change columns into rows in Excel?
I have a huge Excel table that I need to transform into paragraphs for a Word report, and I can't find an efficient way to do it
The source looks like this:
And I would ultimately need something ...
1
vote
3
answers
7k
views
Microsoft Excel - Count the number of values each name has in a single column
I have a CSV file containing 100,000 rows.
Each row consists of information under a number of columns, such as "Date", "Page Accessed", "Page Type", "IP", "User Surname", "User Forename", "User Login"...
1
vote
1
answer
2k
views
Hyperlink to a filtered pivot
Here's what I want to do.
I have a Pivot Table that contains data from more segments. Let's name them A, B, C and D.
I want to have an hyperlink that will open my pivot table directly showing just the ...
1
vote
4
answers
421
views
Determining whether VBA is necessary in Excel, or if a pivot chart/table can suffice
I wish that I had a more precisely descriptive title for this question, but I am not very knowledgeable with Excel spreadsheets or VBA (I'm primarily a Java developer, and don't play much in the ...
0
votes
1
answer
1k
views
Pivot tables: How can I total the subtotal?
My SUBTOTAL row shows Person A needs £115, Person D £234 and Person G £789, but how do I SUM those totals and get it to show the total on the same ROW?
The Rows are subscription names.
The Value ...