ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   delete duplicate rows, keep one (https://www.excelbanter.com/excel-discussion-misc-queries/247013-delete-duplicate-rows-keep-one.html)

Wasdell

delete duplicate rows, keep one
 
I would like to delete duplicate rows but to keep one row

Gary''s Student

delete duplicate rows, keep one
 
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.

--
Gary''s Student - gsnu200908


"Wasdell" wrote:

I would like to delete duplicate rows but to keep one row



All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com