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 which they belong and their number in another column as in the example. What formula should I use for that purpose? Thank you!

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