Forum Discussion
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?
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