as a newbie,I need to get a vb code so i can kick off a macro which will delete duplicates.
Say if a column has all customers, and next column is sales,
Customer Sales
00001 2,000
00001 8,000
00002 3,000
00002 10,000
I need to delete the highest in sales figure only, and only keep the lowest.
please help!!