Hello,
i have big excel file with more 500K entries .. im looking for help to do the following,Example as below:
ColumnX:
22
22
22
33
33
44
11
ColumnY: (Infront of each value in ColumnX)
Red
Blue
Black
Red
Blue
Blue
Black
Now what i want to have to return for me only the value in ColumnX which only have Vlaue with"Red" & "Blue" and if the value have more than "Red" or "Blue" Dont get it for me.
So what what im expecting to see as results back for me is Only "33" is my wanted value and rest are not in the criteria cause either its having more than i want or less.
Thanks.
Bookmarks