All Questions
72
questions
0
votes
0
answers
87
views
Date error in GetPivotData in MS Excel
I have a row with dates, 2018-01-01, 2018-02-01 ... 2020-12-01, that I want to reference to, from a GETPIVOTDATA formula.
I've managed to reference to another cells for Gross Profit, AM, Region, and ...
0
votes
1
answer
52
views
Plotting combined column charts in Excel
I have data like as shown below in csv file for 3 terms such as A, B, C.
I am trying to plot them using a column chart.
Basically what my data indicates (ex: Terms A) is out of 200 items, 150 belongs ...
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 ...
0
votes
0
answers
22
views
How to move specific cells in a row from one worksheet to another based on Month in Month Due column
I have been googling for a while trying to find a solution for how to copy specific cells in a row from one sheet to another. I have only been finding ways to copy entire rows. I have a workbook and ...
0
votes
0
answers
142
views
Create a pie chart for different items with filter
I need to create a pie chart for sold and not sold for 4 items. Items (pen, pencil, book, box) should be in filter. If I click any item my chart should show sold and not sold number.
data.csv:
Item,...
0
votes
0
answers
76
views
Maintaining weighted average proportions in Excel when there is null data
I am not sure how to recalculate weights in Excel, preferably in a PivotTable, when there is null data (i.e., survey administrators didn't write anything).
Please refer to this workbook, where I have ...
0
votes
1
answer
137
views
What Excel function to categorize, sort or lookup values within a cell
I am trying to create a workbook (non-VBA) for collating materials required for student experiments. At the moment, I have a list of all the experiments and their materials. Below is a excerpt of the ...
0
votes
2
answers
58
views
Easiest method of displaying how many instances for each hour?
I have a call log which has thousands of calls in it. Each call is an entry in a CSV file which includes a datetime stamp.
What I would like to be able to do, is easily view how many calls there are ...
0
votes
2
answers
2k
views
How do I summarize a value according to multiple columns in Excel?
Summing a column according to one other column is quite easy with a Pivot table. However, it doesn't seem to be possible with multiple columns.
Similar to R's group by, I want to summarize one value ...
0
votes
2
answers
199
views
How can I combine a column with a row to generate new columns?
I have data stored as an excel file taken from the U.S. Energy Information Administration. The below is a snippet of that data. I want to transfer this to a GIS-usable format. As such, I want to ...
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
157
views
Pivot or Formula for Reverse Lookup
I am creating a list of features and the audiences that will be targeted for those features. Each stakeholder group (audience) is separate by a comma in the list. Now, if I want to create a pivot or ...
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 ...
0
votes
1
answer
409
views
Excel group transposed columns by date
I'm having trouble transposing data to get the format that I'd like. I have pay period end dates in one column and employee names in the other column, and I'd like format it so that each column header ...
0
votes
1
answer
816
views
Excel pivot values column to Text
I have data in Excel pivot and my text data in value column shows number instead of Text . Any one can help me please. In below image of pivot value field red circled: