Цитата
сделать макрос для создания соседнего столбца без индексов
[vba]Код
Sub WithOutIndex()
Dim i As Long
Dim iLastRow As Long
Dim FoundCell As Range
Dim FAdr As String
iLastRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To iLastRow
Set FoundCell = Columns(1).Find(Cells(i, 4), , xlValues, xlPart)
If Not FoundCell Is Nothing Then
FAdr = FoundCell.Address
Do
FoundCell.Offset(, 1) = Cells(i, 4)
Set FoundCell = Columns(1).FindNext(FoundCell)
Loop While FoundCell.Address <> FAdr
End If
Next
End Sub
[/vba]