Forum Discussion
Consolidating Data
I am not a pro at Excel but I did try researching this for some time. This is an example. In column E I have 12,000 items that are duplicates but I want to add them up to show totals of how many time...
that’s what I need I’m. It great at any of this and I made the pivot table not not sure where to drag the items to get it to look like yours.
=IF(ROW(F2)=LARGE(IF($F$2:$F$28=F2,ROW($F$2:$F$28)-1),1)+1,COUNTIF($F$2:$F$28,F2),"")With the help of Riny_van_Eekelen 's solution an alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.