Matching one column against another column of data to show the same amount of data.
 

For example. Column A has 100 values and column B has 50 values. Is there
a function that is able to return Column A and B to show 50 values in order
for me to run a specific function (Linest)with out manually truncating
Column A to have 50 values.

Thanks!