Sub Test()
Dim Tablo(), i%, j%, k%
k = 1
j = 1
While (Sheets(1).Cells(k, 6) <> '')
u = False
For i = 1 To j
ReDim Preserve Tablo(1 To 2, 1 To j)
If Sheets(1).Cells(k, 6) = Tablo(1, i) Then
u = True
Exit For
End If
Next i
If u = False Then
Tablo(1, j) = Sheets(1).Cells(k, 6)
j = j + 1
End If
k = k + 1
Wend
End Sub