Creating a list and removing duplicates

Hi,

Use Data Filter AdvancedFilter Unique Records ...
see attached ...

Originally Posted by JohnGuts

In column A is a list of case #'s. In Column B is a list of employees and in column C is a list of activities. See below

123 Joe Run
321 Ben Jump
123 Tom Sit
123 Ben Run
123 Joe Walk
321 Joe Run

In column A, cases numbers may be entered multiple times.

In column B, employees may be entered multiple times on the same cases or on different cases.

In column C, activities may be entered multiple times on the same cases or on different cases.

What I am trying to do is once the cases, employees and activities have been entered, I want to have a list auto generated that will remove the duplicates from the list. I want to query the user for a case number and when they enter it, I only want to see an activity once (remove display of the same activities for that case #).

for example, if the user inputs case # 123, I want the following return from the array above:

Run
Sit
Walk

Any help would be great as I am stuck. Thanks!

Assuming your data in A2:C7

=IF(ISERR(SMALL(IF(FREQUENCY(IF($A$2:$A$7=123,MATCH($C$2:$C$7,$C$2:$C$7,0)),MATCH($C$2:$C$7,$C$2:$C$7,0)),ROW(INDIRECT("1:"&ROWS($C$2:$C$7)))),ROWS($2:2))),"",INDEX($C$2:$C$7,SMALL(IF(FREQUENCY(IF($A$2:$A$7=123,MATCH($C$2:$C$7,$C$2:$C$7,0)),MATCH($C$2:$C$7,$C$2:$C$7,0)),ROW(INDIRECT("1:"&ROWS($C$2:$C$7)))),ROWS($1:2))))

ctrl+shift+enter, not just enter