New answers tagged


To get that output create pivot, add id1 and name1 as Rows, tick off totals (unnecessary) and add name1 to Values with COUNTA formula


Please try the following formula: =QUERY({B2:C;D2:E}, "select Col1,Col2, count(Col1) where Col1 is not null group by Col1, Col2 label count(Col1) ''") Functions used: QUERY

Top 50 recent answers are included