ExcelBanter - extracting unique rows

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - extracting unique rows (https://www.excelbanter.com/new-users-excel/22711-extracting-unique-rows.html)

DANmcc

extracting unique rows

Hi,
I am trying to remove duplicate rows(consisting of 8 columns or horizontal
cells).
any ideas?

thanks

dan

Gord Dibben

DataFilterAdvanced Filter.

Check "unique records" and "copy to another location"

For more details and pictures see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfi....html#FilterUR

Gord Dibben Excel MVP

On Tue, 19 Apr 2005 17:00:01 -0700, DANmcc
wrote:

Hi,
I am trying to remove duplicate rows(consisting of 8 columns or horizontal
cells).
any ideas?

thanks

dan

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