Filter Email Addresses based on a string exists or not in another field

[Mert]

Hi, 

I have a table like the following:

Email	Value
a@b.com	Active
a@b.com	History
a@b.com	History
c@d.com	History
c@d.com	History
e@f.com	Active
g@h.com	History
k@l.com	Active
m@n.com	History

I want to look at each email (sometimes as a  group if exists more than once) and keep those rows if either value is history and the email repeats only once or that email repeats multiple time however value is never active.

I hope the above sentence is not too complicated :) In case it is, sorry and below is a illustration of what I want to achieve for simplicity:

Email	Value
c@d.com	History
c@d.com	History
g@h.com	History
m@n.com	History

Thank you very much in advance for your help!

[Raj · Accepted solution]

@Mert 
find workflow attached
mark done if solved.