Sort Times from smallest to highest and Text value

**bjnockle** · 01-17-2021, 04:43 PM

Looking for formula to sort times from smallest to largest. Times to be sorted are in column A[/B]. Also in column A is a text value. Would like the formula to sort both the times and text into the desired column in B. See attached sample file.

Thanks.

**TMS** · 01-17-2021, 04:53 PM

Probably a silly question, but why don't you just sort column A?

**bjnockle** · 01-17-2021, 04:55 PM

TMS: The sheet would be locked and hidden to any form of manipulation, which is why I am looking for a formula. Thanks.

**TMS** · 01-17-2021, 05:35 PM

Are you really using Excel 2010? If you are using Excel 2019, there is a Sort function that will probably do what you want.

Not sure if you can do it with a formula given the mixed content.

**AliGW** · 01-17-2021, 06:01 PM

Maybe this:

=SMALL($A$2:$A$15,ROW()-1)

**TMS** · 01-17-2021, 06:14 PM

@Ali: it doesn't cope with the "None" entry.

**MrShorty** · 01-17-2021, 06:18 PM

This seems to work for the example (essentially AliGW's formula wrapped in an IFERROR() to trap the one error value) =IFERROR(SMALL($A$2:$A$15,ROW(B1)),$A$15) It works because there is only one text entry and it is at the bottom of the list. How well does the example represent the real problem?