I have a workbook with 10 sheets. Each sheet will have
50,000 or more rows. Col A is a reference number for each
row of data. Reference numbers are repeated thoughout the
each sheet.

What I need to do is reduce each sheet to only 1 instance
of each unique reference number. I was able to compare
each row to the one above and delete it if the reference
is the same. (for example, each sheet will only contain
7,000 - 9,000 records after it is reviewed.) While this
works it is time-consuming with over 500,000 rows to
review.

Is there a better / quicker way to reduce each sheet to
display 1 instance of each unique value in col A?

Thanks for the help.

If you just want a list of items I would use a PivotTable and copy the list
of reference numbers. There's probably a better way though.

Jeff

"JT" wrote in message
...
I have a workbook with 10 sheets. Each sheet will have
50,000 or more rows. Col A is a reference number for each
row of data. Reference numbers are repeated thoughout the
each sheet.

What I need to do is reduce each sheet to only 1 instance
of each unique reference number. I was able to compare
each row to the one above and delete it if the reference
is the same. (for example, each sheet will only contain
7,000 - 9,000 records after it is reviewed.) While this
works it is time-consuming with over 500,000 rows to
review.

Is there a better / quicker way to reduce each sheet to
display 1 instance of each unique value in col A?

Thanks for the help.

I need all of the data in Columns B:P for each unique
value.


-----Original Message-----
If you just want a list of items I would use a PivotTable
and copy the list
of reference numbers. There's probably a better way
though.

Jeff

"JT" wrote in
message
...
I have a workbook with 10 sheets. Each sheet will have
50,000 or more rows. Col A is a reference number for
each
row of data. Reference numbers are repeated thoughout
the
each sheet.

What I need to do is reduce each sheet to only 1
instance
of each unique reference number. I was able to compare
each row to the one above and delete it if the reference
is the same. (for example, each sheet will only contain
7,000 - 9,000 records after it is reviewed.) While this
works it is time-consuming with over 500,000 rows to
review.

Is there a better / quicker way to reduce each sheet to
display 1 instance of each unique value in col A?

Thanks for the help.


.

You might want to look at: DataFilterAdvanced FilterCopy with unique
records only.

JT wrote:
I need all of the data in Columns B:P for each unique
value.



-----Original Message-----
If you just want a list of items I would use a PivotTable

and copy the list

of reference numbers. There's probably a better way

though.

Jeff

"JT" wrote in

message

...

I have a workbook with 10 sheets. Each sheet will have
50,000 or more rows. Col A is a reference number for

each

row of data. Reference numbers are repeated thoughout

the

each sheet.

What I need to do is reduce each sheet to only 1

instance

of each unique reference number. I was able to compare
each row to the one above and delete it if the reference
is the same. (for example, each sheet will only contain
7,000 - 9,000 records after it is reviewed.) While this
works it is time-consuming with over 500,000 rows to
review.

Is there a better / quicker way to reduce each sheet to
display 1 instance of each unique value in col A?

Thanks for the help.


.