Sorting question

Here is a formula based option.
With reference to the picture below:
Is this what you are looking for?
Can you live with a helper column somewhere in the first worksheet?

OneCol.png

Sheet1!C2: The N() functions avoid having to make a special case of C2

Formula:

=N(C1)+N(B1)

Sheet2!A2 and copied down:

Formula:

=INDEX(Sheet1!$A$2:$A$10, MATCH(ROW()-2, Sheet1!$C$2:$C$10, 1))

The attached workbook implements the above.

That worked. Thank you so much!! This helped me overcome a hurdle on an important project.

Thanks also for the pointers on posting questions, such as attaching an excel file with what I'm looking for. I will heed that advice for the future.

I've noticed many of the posts show "problem solved." Do I need to do something to check that box?

Thanks again,
Keith