Re: Copy duplicate values to new column

[Peter Brawley]

> create a command to

Don't assume the requirement is best met by just one command.

The requirement still has ambiguities ...

> 1) Find IDs which both have a same specific email adress and, more importantly:

Find IDs where? Or do you mean assign IDs? And if the latter, assign what ID to a dupe? A dupe ID? Alternate ID? What?

> 2) Copy the invoice number from the second instance of the email address to another column

For the 2nd, 3rd &c.