Forum Discussion

berkayakr's avatar
berkayakr
Copper Contributor
Dec 12, 2022

Excel Checking the values

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 whic...
Excel
Formulas and Functions
training
  • Harun24HR's avatar
    Harun24HR
    Dec 12, 2022

    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's avatar
Harun24HR
Bronze Contributor
Dec 12, 2022

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"))

 

 

  • berkayakr's avatar
    berkayakr
    Copper Contributor
    Dec 12, 2022
    Thank you for your answer! You helped a lot!!

Resources