Advance filter unique values from third column

[Spoulis19]

I have a table with 3 columns.
Is it possible to use advancefilter to extract unique records from third column without using another help column.

TrialBalanceItem.	ReverseSort	.LenTrialBalanceItem.
* 60.00.00. * ΤΑΚΤΙΚΕΣ ΑΠΟΔΟΧΕΣ 31.596,98 31.596,98	15	96
* 60.00.00. * ΤΑΚΤΙΚΕΣ ΑΠΟΔΟΧΕΣ 31.596,98 31.596,98	15	96
* 60.00.00. * ΤΑΚΤΙΚΕΣ ΑΠΟΔΟΧΕΣ 31.596,98 31.596,98	15	96
100 60.00.03.9002 ΠΡΟΒΛΕΨΗ ΜΙΣΘΟ/ΣΙΑΣ Δ.ΧΡΙΣ/ΝΩΝ 4.340,00 4.340,00	18	98
100 60.00.03.9002 ΠΡΟΒΛΕΨΗ ΜΙΣΘΟ/ΣΙΑΣ Δ.ΧΡΙΣ/ΝΩΝ 4.340,00 4.340,00	18	98
100 60.00.03.9002 ΠΡΟΒΛΕΨΗ ΜΙΣΘΟ/ΣΙΑΣ Δ.ΧΡΙΣ/ΝΩΝ 4.340,00 4.340,00	18	98
100 60.03.00.9006 ΑΝΤΙΛ.ΕΡΓΟΔ.ΕΙΣΦ.ΑΠΟΖ.ΑΔΕΙΑΣ 7.501,67 7.501,67-	88	99
100 60.03.00.9006 ΑΝΤΙΛ.ΕΡΓΟΔ.ΕΙΣΦ.ΑΠΟΖ.ΑΔΕΙΑΣ 7.501,67 7.501,67-	88	99
100 60.03.00.9006 ΑΝΤΙΛ.ΕΡΓΟΔ.ΕΙΣΦ.ΑΠΟΖ.ΑΔΕΙΑΣ 7.501,67 7.501,67-	88	99

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thanks in advance

 

[Aladin Akyurek]

What is the resulting list that you want to see?

 

[Spoulis19]

What is the resulting list that you want to see?

The resulting list is pasted below. Is the solution to format data as table and to select in the range of the advance filter only the one column of the entire table; TrialBalanceItem	ReverseSort	LenTrialBalanceItem
* 60.00.00. * ΤΑΚΤΙΚΕΣ ΑΠΟΔΟΧΕΣ 31.596,98 31.596,98	15	96
100 60.00.03.9002 ΠΡΟΒΛΕΨΗ ΜΙΣΘΟ/ΣΙΑΣ Δ.ΧΡΙΣ/ΝΩΝ 4.340,00 4.340,00	18	98
100 60.03.00.9006 ΑΝΤΙΛ.ΕΡΓΟΔ.ΕΙΣΦ.ΑΠΟΖ.ΑΔΕΙΑΣ 7.501,67 7.501,67-	88	99

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Let A:C of Sheet1 house the data from the first row on.

Sheet2 (The results sheet)

A1 must be left empty.

A2:

=COUNTIF(Sheet1!$C$2:$C2,Sheet1!C2)=1

1. Select A1:A2

2. Fire up Advanced Filter

3. Click OK

4. Check the option Copy to another location

5. Set List range as: Sheet1!$A$1:$C$10

6. Set Criteria range as Sheet2!$A$1:$A$2

7. Set Copy to as: Sheet2$A$3

8. Click OK.

 

[Spoulis19]

Thank you, it works!!!

 

[Aladin Akyurek]

Thank you, it works!!!

You are welcome.