Forum Discussion

Brass Contributor

Feb 08, 2021

Suggestions on how to remove duplicate user id/passwords/notes from different sources?

Hello. I have many outdated userids and passwords saved in a third party application called Bitwarden. I use this as a backup to Google Chrome. Both Google Chrome and Bitwarden all import and export ...

excel

Formulas and Functions

mathetes

Gold Contributor

Feb 08, 2021

JustANoob

If you have access to the UNIQUE function--requires the most recent version of Excel--you could use it to produce a list of the unique combos of userID and pw. Just combine the files from both of your current lists and get those unique combos.... then update that further, with your notes, and then export.

However, what I'd really recommend is getting a package like 1Password and going through both of your files patiently and entering the new data into 1Password (or whatever). Then they'd be safe and secure and accessible to you on any and all of your devices. https://1password.com/

I used to have a homegrown system myself ... begun back in the days of the Palm Pilot (do you remember those?) -- but now rely on 1Password. It took a while to transfer all the data over, manually as I recall.......but well worth it.

JustANoob

Brass Contributor

Feb 09, 2021

Hi. Thank you for replying. Do you know if the UNIQUE function works with Office 2019 or the free Excel version via One Drive and your Outlook account? If yes, can you please elaborate on how to accomplish what you mean? As I mentioned I'm a noob and I wouldn't know how to combine the two files. I'll need detailed instructions on how to do that and how to use or create a formula using the UNIQUE function.

I have 1Password (the free version) and Roboform. It's just too time-consuming to go through 900+ passwords. That;'s why I am looking to automate the process. I hope to hear back from you.