Hi to all,
I have data like this,
mat F M
p1 x y
p2 a b
p3 c d
p4 x y
p5 x y
p6 e f
p7 j k
p8 x y
p9 r r
p10 x y
now i want to get mat numbers having same F and M combinations, for example i am expecting to get p1,p4,p5,p8 and p10 because they have same F and M combinations. i need to work out this with formula because i have very big file contains lot of data like this. I am attaching sample file for better understanding. any help would be appreciated
Thanks in advance![]()
Bookmarks