Sunday, October 30, 2016

yogi_Counts The Number Of Times Each Value In B Appears In Column B for Each Group In A

Google Spreadsheet   Post  #2079
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-30-2016
question by: michaeldon:!topic/docs/uJEi_e2avdw;context-place=forum/docs

How to count number of times the value in each row occurs with arrayformula

Hello All

If I have data like the screen shot, and I want to count the number of times each value in column B appears for a group in column A I can use the formula =countifs(A:A,A1,B:B,B1) and paste it into every cell in Column C.

But what if I want to use an arrayformula? Countifs cannot be used with arrayformula and I have found it impossible to replicate this result using IF or countif