I have 2 different independent columns. Column A is claim number and column B is bill amount. There are 22000 rows. What I am trying to do is match all claim numbers where there are bill amounts of 0. After I get that I want to only show the claim numbers that have duplicates and have a bill amount of 0. I need to keep duplicate claim numbers only if one of the matching claim numbers has a bill value of 0.

Is there a formula to do this?

Claim # Bill Amnt
5315945 0.00
6248561 120.00
.... ....