Align Excel Data in Colum's

Question

Hi There, Can someone tell me how to Align the data in Column C, to the data in column D?

oliverscheurich · Answer

JacquesRedding&nbsp;=INDEX($C$1:$C$26,MATCH(D1,$C$1:$C$26,0))Does this return the intended result?&nbsp;

jacquesredding · Answer

OliverScheurich&nbsp;Hi, Thanks, but no&nbsp;still not doing anything&nbsp;&nbsp;

hansvogelaar · Answer

JacquesRedding&nbsp;
If you use comma as decimal separator, use
=INDEX($C$1:$C$26;MATCH(D1;$C$1:$C$26;0))
Here is a macro that will align column D in place:
Sub AlignD()
    Dim rc As Long
    Dim rd As Long
    Dim mc As Long
    Dim md
    Dim vc()
    Dim vd()
    Dim vn()
    Dim t As Single
    Application.ScreenUpdating = False
    t = Timer
    mc = Range("C1").End(xlDown).Row
    vc = Range("C1:C" &amp; mc).Value
    ReDim vn(1 To mc, 1 To 1)
    md = Range("D1").End(xlDown).Row
    vd = Range("D1:D" &amp; md).Value
    For rd = 1 To md
       rc = Application.Match(vd(rd, 1), vc, 0)
       vn(rc, 1) = vc(rc, 1)
    Next rd
    Range("D1:D" &amp; mc).Value = vn
    t = Timer - t
    Debug.Print t
    Application.ScreenUpdating = True
End Sub

oliverscheurich · Answer

JacquesRedding&nbsp;HansVogelaar&nbsp;already explained why the problem occurs. If you open the attached file the formula is shown in your language.&nbsp;An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

Forum Discussion

Align Excel Data in Colum's

Share

Resources