sorting and extracting data

[etradeguru]

Hi there.
Okay. Here is my problem (apart from Excel 2000!). I have extracted a
list of data (some 36000 rows in all) and then subtotalled it.
The example below is a small extract.
Each subtotal line has the word average at the end.
What I want to do is to look at the groups of data for each
subtotalled chunk of data and do the following: -

1. for each change in ColB, I want to sort by user and then remove all
duplicate users ( entire row) for that report name.
2. extract a report, to another sheet/file that will list the report
name and the users who have run the report.

so using Data Import as an example, the duplicate entries for Andrew
and David would be deleted, and the report would show that for Data
Import, Geoffrey, David, Andrew, Nicola and David ran the report.

Some reports will have only one entry, as is the entry for data import
execution & AutoReconciliation run by John

The 'average' line can be discarded.

Col A ColB
Geoffrey Data Import
David Data Import
Andrew Data Import
Nicola Data Import
Andrew Data Import
David Data Import
Data Import Average
John data import execution & AutoReconciliation
data import execution &AutoReconciliation Average
Geoffrey data import execution Report
David data import execution Report
Andrew data import execution Report
Nicola data import execution Report
Andrew data import execution Report
David data import execution Report
data import execution Report Average

Names have been changed to protect the innocent!

Hope the above makes sense.
Thank you in advance.
Mark

 

[etradeguru]

Hi there.
Okay. Here is my problem (apart from Excel 2000!). I have extracted a
list of data (some 36000 rows in all) and then subtotalled it.
The example below is a small extract.
Each subtotal line has the word average at the end.
What I want to do is to look at the groups of data for each
subtotalled chunk of data and do the following: -

1. for each change in ColB, I want to sort by user and then remove all
duplicate users ( entire row) for that report name.
2. extract a report, to another sheet/file that will list the report
name and the users who have run the report.

so using Data Import as an example, the duplicate entries for Andrew
and David would be deleted, and the report would show that for Data
Import, Geoffrey, David, Andrew, Nicola and David ran the report.

Some reports will have only one entry, as is the entry for data import
execution & AutoReconciliation run by John

The 'average' line can be discarded.

Col A ColB
Geoffrey Data Import
David Data Import
Andrew Data Import
Nicola Data Import
Andrew Data Import
David Data Import
Data Import Average
John data import execution & AutoReconciliation
data import execution &AutoReconciliation Average
Geoffrey data import execution Report
David data import execution Report
Andrew data import execution Report
Nicola data import execution Report
Andrew data import execution Report
David data import execution Report
data import execution Report Average

Names have been changed to protect the innocent!

Hope the above makes sense.
Thank you in advance.
Mark

I should add that the data is a copy\paste special\values from the
subtotalled sheet so it will behave normally.