eliminate records based on 3 criteria!

[cyoung315]

I am bringing in a set of data from another application which includes the following: NAME, DATE VIEWED and SCORE. These are the results of users viewing an online lesson and taking the accompanying test. Users may view the lesson as many times as they want and take the test as often as they want. How can I eliminate all results but the first time the user views the lesson and attempts the test?

Thanks in advance for the help!

[Loz]

One suggestion is as follows...

(a) Sort the list by NAME, then by DATE VIEWED (ascending)

(b) Add an additional column (column D presumably), calling it say "First Viewed" in D1, with the formula in D2...

=(A2<>A1)

Copy this formula down the column. It will show True when the name is different to the previous row, or False if it is the same.

(c) You can now filter the list based on column D True values.

(d) The filtered list of rows can be copied and pasted to a fresh worksheet.

[starguy]

I am bringing in a set of data from another application which includes the following: NAME, DATE VIEWED and SCORE. These are the results of users viewing an online lesson and taking the accompanying test. Users may view the lesson as many times as they want and take the test as often as they want. How can I eliminate all results but the first time the user views the lesson and attempts the test?

Thanks in advance for the help!

Please avoid duplicate posts.

http://www.excelforum.com/showthread.php?t=597952