ExcelBanter - Sorting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sorting (https://www.excelbanter.com/excel-worksheet-functions/125259-sorting.html)

tcidawn

Sorting

We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have
done it before, but I am having a brain freeze.

Thanks

Dave Peterson

Sorting

Use another column with formulas like:

=mid(a1,4,4)

and then sort your data by that column.

tcidawn wrote:

We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have
done it before, but I am having a brain freeze.

Thanks

--

Dave Peterson

Teethless mama

Sorting

You could create a Helper column
=MID(A1,4,4)
then sort by that column

"tcidawn" wrote:

We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have
done it before, but I am having a brain freeze.

Thanks

Teethless mama

Sorting

=--MID(A1,4,4)

"tcidawn" wrote:

We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have
done it before, but I am having a brain freeze.

Thanks

All times are GMT +1. The time now is 05:05 AM.