Hello all,

hoepfully you can help.

I am currently running daily uploads into our database, and the data provided to me is in a CSV format, and consists of around 20 columns (it's address data)

my issue is that if we're uploading to address types to a reference, column B needs to bo populated with a B, instead of a P.

now, column E is the reference, and column F is the address type (main or Corr)

i can obviously sort the cells absolutely fine, but i need either i way of quickly identifying the duplicates, and correcting Column B for the 'Corr' address, or some help in writing a macro for it.

many thanks, Karl