Forum Discussion

mlefler75's avatar
mlefler75
Copper Contributor
Jan 06, 2022

sorting uneven rows

I have two columns of data in excel, one has more rows than the other, is there anyway to sort them so that the data that is the same in each row lines up?

1 Reply

  • alannavarro's avatar
    alannavarro
    Iron Contributor

    mlefler75 

    Maybe there is another simple way to do it, attached is an excel file with an example.

     

    In youtube here is the explanation of the dynamic array formula.

    https://www.youtube.com/watch?v=4qZ8ud8akus 

Resources