Search results

Can you please upload same data set. You can also refer below urls Right click on the Pivot Table - "Pivot Table Options" - Select the "Display" tab - The bottom section controls the "Field List" -Sort A to Z / Sort in data source order...

Hey Ikhan, Use below array formula with crt+shft+enter cell p15 = =SUM(IFERROR(SEARCH(P$14,$B15:$O15),0)*--IFERROR(RIGHT($B15:$O15,LEN($B15:$O15)-1),0))

Change A1 value to 50 (current is 20) ctrl+h to replace find what Sheet1!$A$2:$A$1002 replace with Sheet1!$B$2:$B$50000

Can you please upload same sheet with required output

Please see the temp solution :)

There is two ways to do this - 1) make another sheet with formula (attached) 2) thru VBA (macro)

Please share few info. What is excel version What is save file extn. Any error? In this on pivot table? are you using name range? share your excel setting like External content, protected view and advanced setting try with stop auto update

Can you please upload sample data set with your required output

Please upload sample data set.

Sir, As I understand with sample data set You are using sum function in "Month D2" and by nature sum returns 0 if no value to sum hence average would consider this as value. I suggest you to please change your sum formula like instant of SUM(F2:AJ2) use if(SUM(F2:AJ2)=0,"",SUM(F2:AJ2)) than...

Yes, was mentioned this ":awesome: means awesome, also with my last post just wanted to understand what you said :) Thanks

this is very normal requirement and we discussed this many times on this group. http://chandoo.org/forum/search/1996046/?q=concatenate&o=date&c[node]=4 https://www.google.co.in/?gfe_rd=cr&ei=CPWpV87cLZXAuATWhL24Bg&gws_rd=ssl#q=concatenate+multiple+rows+in+one+cell

you can refer below url http://www.mrexcel.com/forum/excel-questions/509428-sumif-countif-visible-cells-only.html

Hi Lori, Can you please help this to elaborate little more to understand this :)

Also, please share the sample output,

Have used running count in your dump data to calculation number of occurrence then converted into 0-1 value and call in pivot table for xlsb extn. I have save in .xlsb to reduce file size ,you can save this with .xlsx also.

:C: @bosco_yip @David @Nebu