All Questions
72
questions
1
vote
2
answers
126
views
How do I count rows with similar data in 2 columns as 1 data entry?
The SPC program test data is entered into is not able to perform compliance validation. Below is an image of data exported to excel. If the date and time are an exact match, it is considered 1 ...
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) ...
0
votes
2
answers
3k
views
In Excel, I am trying to calculate a percentage of two sums
I have a rather large dataset, 44 columns and about 8k to 9k rows each month. The table has every trip that our customers have either completed or not shown up for. I have started with a simple pivot ...
0
votes
2
answers
2k
views
Pivot table representing data as parent/child rather than desired summary of totals
Ok, so struggling with a pivot table and I'm not sure of how to phrase the title exactly, so apologies if it isn't 100% accurate.
Please ask for more information where it is lacking in my description....
0
votes
1
answer
20k
views
Excel Pivot Table - How can I return a date in the row value?
I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the ...
1
vote
1
answer
88
views
Calculate % of filtered values from all values in Excel Pivot Table
I have this pivot table that currently shows how many students failed in a particular subject in a particular academic year. That is, it is now filtered by Pass_Status Fail(which can be either Pass or ...
0
votes
0
answers
75
views
Filtering Pivot Table
I have this Pivot Table, and what I need to do is: Filter this data and show only those records whose date (3rd column) is equal to its parent date (2nd column) or just 1 day difference is there.
And ...
0
votes
1
answer
481
views
Automated weighted counts in a Pivot Table (Excel)
I have data for sales people who work with different clients. Sometimes the sales person has multiple deals with the same client. I want to be able to work out the count for each sales person for each ...
1
vote
1
answer
758
views
Advanced data consolidation in Excel
I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...
0
votes
2
answers
2k
views
Find most frequently used value
I know that that question has been asked before but my question needs more scalable solution!
I have a column G with States, there are 10,000 States in that column.
I need to find out what is most ...
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 ...
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 ...
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 +
++++++++++++++++++++++++++++++++++++++++++++++++...
1
vote
1
answer
4k
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
2k
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 ...