Home Tags Advanced filter

Tag: advanced filter

Use Advanced Filter to Remove Duplicates from your Database in Excel

I love databases. It's true. I'm a secret geek and I love finding new ways of working with Excel and making it do things...

Painlessly extracting the data you need from a database – Part...

In our previous article, we looked at using the Advanced Filter function of Excel to copy certain records from one database to another using...

Painlessly extracting the data you need from a database

A common use for Excel spreadsheets is to create databases of contacts or event attendees but a mere spreadsheet of names and details isn't...

DON'T MISS