I would like to delete duplicate rows but to keep one row
G Gary''s Student Oct 30, 2009 #2 Very simple. Say we have 150 rows. Starting with row # 150, compare each cell in row #150 with the cells in the rows above it. If for some earlier row, all the cells match, then delete row #150 and repeat the process moving upwards.
Very simple. Say we have 150 rows. Starting with row # 150, compare each cell in row #150 with the cells in the rows above it. If for some earlier row, all the cells match, then delete row #150 and repeat the process moving upwards.
