I would like a forumla to populate G2, G3 and G4, using the data from A and B
Thanks
I would like a forumla to populate G2, G3 and G4, using the data from A and B
Thanks
Another 2 options
=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,(ROW($A$2:$A$10)-ROW($A$2)+1)/($B$2:$B$10="Fruit"),ROWS(G$2:G2))),"")
or if you have dynamic arrays
=FILTER(A2:A10,B2:B10="Fruit")
filter command i believe is only for 365 users
At the moment only some 365 users have it.
But I put it there as I have no idea what version the OP is running.
THANK YOU
Glad we could help & thanks for the feedback
I need to amend this slightly to only bring back the data if there is data in column c.
Did the Filter formula I supplied, work for you?
Any chance you could answer my question?
And answer came there none.
In that case try
=FILTER(A2:A10,(B2:B10=G1)*(C2:C10<>""))
or
=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,(ROW($A$2:$A$10)-ROW($A$2)+1)/(($B$2:$B$10=$G$1)*($C$2:$C$10<>"")),ROWS(G$2:G2))),"")
Don’t have an account yet? Register yourself now and be a part of our community!