Jan 06 2022 02:32 PM
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?
Jan 06 2022 06:49 PM
@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.