Search results

I've attached a sample file to hopefully explain this better. So in the PT I have two fields calculating the number of fruit sold per year with year being the only column value. The 2nd fruit sold value is: Show field value as difference from Base field: year Base item: previous I'm trying to...

I also posted this question at: https://www.excelforum.com/excel-charting-and-pivots/1242780-pivot-table-sorting-on-calculated-field.html#post4961630 https://www.mrexcel.com/forum/excel-questions/1068107-pivot-table-sorting-calculated-field.html#post5129923

Hi, I have a PT with 4 years of data in it. I'm creating calculated fields to show the difference in sales and % of difference in sales for 2017 and 2018. Those are the only two years I'm showing in the report with Year being a column value. Because I want to see the difference in sales between...

solved =INDEX(Sheet2!$B$2:$K$8,MATCH($A2,Sheet2!$A$2:$A$8,0),SMALL(IF(LEFT(Sheet2!$B$1:$K$1)=T$1,COLUMN(Sheet2!$B$1:$K$1)-1),COUNTIF($A$2:$A2,$A2)))

I attached a new sample workbook with what I would like the desired output to look like.

Hi, I'm trying to use a formula I've used before but not it's giving me a reference error. I'm trying to move the data from sheet two over into sheet one so that instead of being on a single row it gets transposed into the column where Column A matches for both sheets. The formulas I was using...

also worked for me thank you

Solved!!! here was the solution =IF(OR(C2={"","0"}),"",IF(LEFT(C2,1)="8","0"&C2,""&C2))

The original doc is coming from a web excel file so I'm converting the number numbers to text before using the formulas I've tried and I'm not sure if that is causing me issues.

Also posted at: https://www.excelforum.com/excel-general/1196543-countif-function-help.html#post4718711 https://www.mrexcel.com/forum/excel-questions/1018381-countif-function-help.html#post4886921

I'm having trouble with the countif function. In my spreadsheet in column C starting cell C2 I have text numbers. If the cell starts with an 8 I want to put a leading 0 in front of it otherwise I want to keep the cell the way it is. Also, if possible for the cells with just a 0 in them can I...

that worked. thanks for all the help

I attached a sample workbook. I will give that a try Narayan

Also posted at: https://www.excelforum.com/excel-formulas-and-functions/1192549-index-match-how-to-avoid-blank-cells.html#post4695592 https://www.mrexcel.com/forum/excel-questions/1013895-index-match-how-avoid-blank-cells.html#post4866015

Hi, I'm trying to use an index match and the column where I'm trying to return data has blank cells in it. The formula I tried but didn't work was: =INDEX(F2:F2000,IF(F2:F2000<>"",MATCH,A1,A2:A2000,0))) The problem I'm running into is that the data I'm trying to return on an entry occurs...

Also posted at https://www.excelforum.com/excel-charting-and-pivots/1188180-pivot-help-creating-a-calculated-field.html#post4670943 https://www.mrexcel.com/forum/excel-questions/1008533-pivot-table-help-calculated-field-creation.html#post4840960

I have a PT that is doing a sum of orders and sales for a given year. Also in there is the number of return orders that occurred in that year. How can I create a calculated field to see the percentage of orders where a return occurred? When I try to do it within the actual PT in the...

thank you.

They'd be the same columns in both. Are running the PQ would the PP just be pulling the data from excel within other sources to get the PQ's data? Or do you have the PQ place the data somewhere else for the PP to grab?

But two tables wouldn't have anything related other then the fact that they're orders. There's not a common link between the two since there would be different orders in each table. And since our system separates invoiced and non-invoiced orders I'd like data getting dumped into excel to have...

Also posted this at: https://www.excelforum.com/excel-charting-and-pivots/1186004-power-pivot-merge-two-tables-to-get-one-output.html#post4657786 https://www.mrexcel.com/forum/excel-questions/1005905-power-pivot-merge-two-tables-get-one-output.html#post4827703

Is it possible within PP to have two tables get dumped together to work with at the same time in PP? Our sales data comes from two separate tables depending on if it's been invoiced or not and I would like to take all the data as a whole to work with in PP at the same time.

that worked. thank you.

Also posted this at: https://www.mrexcel.com/forum/excel-questions/1004888-extract-string.html#post4822660 https://www.excelforum.com/excel-general/1185191-extract-from-a-string.html#post4652652

Hi, I'm trying to be able to pull out a number from column G in the attachment. What I'm needing is whenever there is not a 9 digit number in column D beginning with 100,it comes over as a text field of the server btw, then it searches column G for that number. In column G that number always...