0
votes
1answer
37 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
1answer
22 views

How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...
2
votes
1answer
39 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 ...
1
vote
1answer
30 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
0answers
82 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 ...
3
votes
2answers
69 views

Count first occurrence of one criterion based on a second criterion

I am trying to write an excel formula (or formulas) to count the first occurrence of a value in a given year for each Person in my table. I've searched for related questions on Superuser to no avail. ...
0
votes
1answer
117 views

Getting average of data with multiple entries for a single date using Pivot table in Excel

I have tried this, but I am unsuccessful. I have the data dump in an excel sheet (Excel 2010). The first column has month. The second has the dates. The third column has numerical data. I have applied ...
1
vote
1answer
1k 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 ...
0
votes
1answer
172 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 ...
2
votes
1answer
510 views

Excel2007 Pivot Table: Get Percentage with respect to number of different values in a field

I have a pivot table based on the answers of N persons to M different questions. Simple Example (in reality their might be more categories for answering than "yes" and "no" and there might also be ...
4
votes
2answers
673 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
3answers
1k 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
3answers
4k 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 ...
0
votes
1answer
210 views

Excel Pivot Table Calculated Field including LEN

I'd like to setup a pivot table field that counts the number of characters in a given field. LEN([field name]) only returns 1 for every row.
1
vote
1answer
287 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
4answers
325 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 ...
1
vote
1answer
2k views

Excel Pivot: How can I show the % of the sub-total against the Grand total?

I have 15 colleagues who have answered 'numerous questions' over the years in a questionnaire. The questions used to be standardised and all colleagues had the same questions. Unfortunately standards ...
0
votes
1answer
767 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 ...