All Questions
72
questions
6
votes
1
answer
31k
views
Working with Averages in Pivot Table (Calculated Field)
I have the following data :
customer_id customer_name id date contract_value costs profit_extra_work
200027 Company A 00.161.559 08/07/2015 499.5 50.55 0
...
4
votes
1
answer
32k
views
How can I get the number of rows in an Excel pivot table for use outside the pivot table?
I have a pivot table in Excel of the form:
Country Server Status
Australia AU1 1
AU2 1
AU3 4
New Zealand NZ1 4
NZ2 ...
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 ...
4
votes
1
answer
32k
views
How to convert data in Excel to percentages of total?
Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't ...
4
votes
2
answers
5k
views
Hierarchical or recursive counting in excel (preferably within a pivot table)?
I'm trying to find a way to aggregate data in a hierarchical data set, preferably within a pivot table but other methods might be OK as well. Consider a data set (greatly simplified for the example) ...
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 ...
3
votes
2
answers
9k
views
Count Row and Column in Pivot Table
Hi I have a sheet that collects the following
++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Name + Address + Borough + Postcode + Date Added +
++++++++++++++++++++++++++++++++++++++++++++++++...
2
votes
1
answer
1k
views
PivotTable Calculated Item IF Statement Issue
I have two columns of data in a pivot table but one of the columns is only partially populated. I've been able to use 'Calculated Item' to add a third column that will calculate the difference between ...
2
votes
1
answer
830
views
Excel Formula...Complex...Invoice tracking without inputting info into multiple spreadsheets
I have a list of store# in one worksheet(1) and another worksheet which has (2)invoice tracking for these stores. As the store# & invoice # are added to one worksheet(2), I want the invoice number ...
2
votes
1
answer
6k
views
Grand Total Not Displaying Correctly for Pivot Table's Calculated Field
I have the calculated field Break Lateness to determine how late an agent is from Break 1 by using the following formula:
IF( 'Break 1' > TIME(0,15,0) , 'Break 1' - TIME(0,15,0), TIME(0,0,0) )
...
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
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
2
answers
594
views
Excel Pivot Table Formula
I have an excel sheet that contains data like that shown below. I have the pivot table that shows departmental time and percent and an external value of total cost.
How do I create a formula that ...
1
vote
2
answers
1k
views
Remove column names from formulae (Convert into regular cell coordinates without sheet names)
I have a defined table of several rows and columns containing data and formulae. Some of the columns' cells' formulae are:
=[@[Weight]]*1000
Where 'Weight' is the name of a column heading.
I want ...
1
vote
1
answer
23k
views
How can I assign an asterisk to a cell which has been formatted as 'Currency' and is also used as raw data for a Pivot Table?
I have a spreadsheet full of raw data, where I have created a Pivot Table to help organise and manage said raw data.
For the purposes of this question, I would like to use the below image to help ...