Sorting two data-sets of numerical values into one without losing numerical order

[Gknight20]

Hi,

I'm trying to sort two sets of data into one and am hoping that there is a way of sorting the two sets together whilst maintaining the numerical values of both.

So, for example, say I have a data set of even numbers (2, 4, 6, 8, 10 etc.) and a data set of odd numbers (1, 3, 5, 7, 9), is there a way to get the numbers to go from 1 - 10 without copying one set underneath the order and then ordering smallest - largest?

The data I am working with has formulae at the end which will mess up if I dump one on top of the other.

Thanks.

[Sunny18pc]

I doubt, any how going to sort the 2 set into one your original database any how would be disturbed.

You can go with this formula =min(small(array1,row ref),small(array2,row ref))

[Sunny18pc]

If this doesn't works then attach your file to suggest better, check the yellow banner how to attach file.