[Dxbase] Confirmed LoTW Contacts

[Bob Main]

I checked my LoTW contacts the other day and found that I had about 7 new
ones since the last time I had checked.  When I started checking I found
that most of them had already been marked as confirmed over a year ago.  I
sent LoTW an email and they said that if the person sends the contact in
again that it replaces the original one.  Now I'm confused because I had 7
QSL less the last time I checked and if the new ones replaced the old ones
then what/where are the 5 new ones?

So what I am wondering is there an easy way to find out what these five are
that appear to be now missing?  I think there is a way I can pull the
information from DXB with a report that I created years ago and modify it to
give me the information that I am looking for.  On the LOTW front I am
looking at downloading that file format they have and convert it into a
comma delimited file and import it into Excel.  Then compare the list to see
who is missing.

Is there an easier way?

Thanks,
Bob
KB4CL