I am having a little trouble with a process I’m developing. I need to take a user ID, name and email from a spreadsheet, and email the user. If a user ID is the same as the previous, the item in the spreadsheet needs to be removed. For example,
The row in red shows the same user ID as the one above it, so the row in red needs to be removed. How would I go about doing this? I am completely stuck, so any input would be helpful.
Thanks in advance!