New answers tagged

2

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


1

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