Excel Checking the values

Copper Contributor

I have a set of data that includes names and groups. What I want to do is, when I insert a group of name in the insert field every time, I want to see the names, under the group title to which they belong and their number in another column as in the example. What formula should I use for that purpose? Thank you!


2 Replies
best response confirmed by berkayakr (Copper Contributor)

@berkayakr Use FILTER() with COUNTIFS() function. See the attachment.


For Group-B only change group in second part of filter function.





Thank you for your answer! You helped a lot!!