SOLVED

Excel Checking the values

Copper Contributor

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!

Excel_check.jpeg

2 Replies
best response confirmed by berkayakr (Copper Contributor)
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"))

Harun24HR_0-1670839677481.png

 

 

Thank you for your answer! You helped a lot!!
1 best response

Accepted Solutions
best response confirmed by berkayakr (Copper Contributor)
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"))

Harun24HR_0-1670839677481.png

 

 

View solution in original post