Thread: Pivot Table-using filters or groups
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pivot Table-using filters or groups
The curly brackets {} mean that the formula
is an array formula and has to be entered
with SHIFT+CTRL+ENTER
I could have used
=SUMPRODUCT(1/COUNTIF(Cust,Cust))-Winners
which requires only ENTER
Reply With QuoteReply With Quote