Forum Discussion
Hi! - asking for a solution to an equation that has me stumped, if I may...
I am a bit further along than beginner, but by no means advanced, so please forgive me if my query seems obvious to someone. But I have tried to build an equation to solve the following problem, an...
Tamara9927 With Microsoft-365 you can try below formulas. BYROW will give you result without entering it to each cell. It will spill all the results automatically.
=AND(FILTER($B$1:$B$7,$A$1:$A$7=A1))
BYROW dynamic array approach. See the attachment.
=BYROW(A1:A7,LAMBDA(x,AND(FILTER($B$1:$B$7,$A$1:$A$7=x))))
And if you do not have Office365 then could use below formula for all versions of excel.
=IF(SUMPRODUCT(--($A$2:$A$8=A2)*(1/COUNTIFS($A$2:$A$8,$A$2:$A$8,$B$2:$B$8,$B$2:$B$8)))=1,B2,FALSE)
Oh my GOODNESS!! yay!!! Thank you!! I will try this!! : ))))