# Tagged Questions

**2**

votes

**1**answer

34 views

### Can I use table relationships in formulas?

Are table relationships only for pivot tables & charts, or can they be used in formulas too? The introduction of tables made it easy to write really readable sumifs like this:
...

**0**

votes

**1**answer

44 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

**1**answer

29 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

**1**answer

47 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

**1**answer

32 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

85 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

**2**answers

70 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

**1**answer

129 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

**1**answer

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

**1**answer

174 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

**1**answer

537 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

**2**answers

679 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

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

**3**answers

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

**1**answer

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

**1**answer

295 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

326 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

**1**answer

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

**1**answer

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