Display Data

[Kenshin]

Please i need help to crack this problem



thanks Ninjas

 

[GraH - Guido]

this can be done...
Be aware I have used aggregate, so your Excel version should at least be 2010.

 

[Kenshin]

Thanks Guido but its different with my desired results, I need to display data with criteria "Leader" with their members. It means the leader have their own data and so their members, i want to display this data

 

[Kenshin]

Somebody help please.....?

 

[rahulshewale1]

Hii @Kenshin ,


See if it is ok ? using helper column


Regard

Rahul shewale

 

[bosco_yip]

Hii @Kenshin ,


See if it is ok ? using helper column


Regard

Rahul shewale

Hi Rahul shewale,

1] Helper column is not required.

2] In F7, copied right to G7 and all copied down :

=IFERROR(INDEX(Data!B$4:B$44,AGGREGATE(15,6,ROW(Data!$B$4:$B$44)-ROW(Data!$B$3)/((Data!$B$4:$B$44=$B$3)+(Data!$C$4:$C$44=$B$3)),ROWS($1:1))),"")

3] See attachment

Regards
Bosco

 

[GraH - Guido]

Thanks Guido but its different with my desired results, I need to display data with criteria "Leader" with their members. It means the leader have their own data and so their members, i want to display this data

Now I'm puzzled. If you change the cell containing the name of the leader, the table is updated, no? And it seems Bosco has provided a variance of the same technique in his solution. Did I really understand your query so badly?

 

[Kenshin]

Thank you all Bosco formula works well, I didn't notice before Bosco use "plus" operator rather "*"

 

[rahulshewale1]

Hii @Kenshin ,

Visit below Link.


https://exceljet.net/formula/sum-if-equal-to-either-x-or-y

Regard
Rahul shewale

 

[Kenshin]

Thanks too to Rahul for the help and the links, thank you