All Questions
3
questions
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 ...
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 +
++++++++++++++++++++++++++++++++++++++++++++++++...
-3
votes
1
answer
306
views
Excel - sumproduct/sumif
I am able to look up single values that meet multiple criterion; but I would like to do more, I want to sum up values that meet two conditions - year and country like in my example. I tried it in my ...