I have a list of data and columns c,d, and e have all unique data. however some companies have more than one entry, and their name appears sometimes 8 times. I want to eliminate all but the topmost company name from t he dups. I'm assuming I need a switch statement, but I'm not sure. any ideas?