Anooo... na to budeme musiet pouzit asi makra, ak jed dalo by sa to spravit aj inac.
Takze skus makro:
----------------------------
Sub Test()
Dim c As Range, d As Range, LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For Each c In Range("A1:A" & LR)
If Not WorksheetFunction.CountIf(Range("B1:B" & LR), c.Value) >= 1 Then
i = i + 1
Range("C" & i).Value = c.Value
End If
Next c
End Sub
----------------------------
Teda aspon mne to funguje - vyhlada obsah bunky stlpca A v stlpci B, a ak ho nenajde, tak ho zapise do stlpca C. Tym padom sice polozky nevymazes, ale do stlpca C ti zapise hodnoty ktore su jedinecne a ktore sa neopakuju. Myslim ze by ti to mohlo pomoct. No a zacina sa or riadku 1, cize ak tam mas hlavicku, tak si v makre prepis zaciatok napr. na A2 a B2, pripadne podla potreby.
Jednoduchsi sposob je pouzit modul
http://www.ablebits.com/excel-remove...ates/index.php, ale je to len trial na 30 dni a potom chcu 23€ (aj ked ak take nieco pouzivas casto, tak sa to asi vyplati).