Recent content by lwilt

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...