sorry, I couldn't figure out how to edit my post, but I made a mistake. how can I make it so that the duplicates rows are deleted and i'm left with what's in the second column of the original post. my apologies. by the way, how does one edit their posts? I couldn't find the edit button on the page. could it be that i'm using a tablet?