Excel Checking the values

[berkayakr]

Hello,
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 · Accepted solution]

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

=FILTER(B2:C10,COUNTIFS(E2:E6,B2:B10)*(A2:A10="A"))

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

=FILTER(B2:C10,COUNTIFS(E2:E6,B2:B10)*(A2:A10="B"))

[#3]

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