ExcelBanter - SORT UPC IN ONE COLUMN BY LIKE NUNBERS

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

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

- - SORT UPC IN ONE COLUMN BY LIKE NUNBERS (https://www.excelbanter.com/excel-worksheet-functions/198640-sort-upc-one-column-like-nunbers.html)

PAUL

SORT UPC IN ONE COLUMN BY LIKE NUNBERS

I WOULD LIKE TO SORT UPC, ALL IN ONE COLUMN, SO THAT ONLY UPC S WITH THE SAME
ONES WOULD BE TOGETHER.
00000000001111187184
00000000001121000660
00000000001380015172
00000000001540085186
00000000001540086412
00000000002100067840
00000000002100067846
00000000002100067916
00000000002100067922
00000000002100068347
00000000001111187176
00000000001111187184
00000000001121000660
00000000001380015172
00000000001540085186

Bob Bridges

SORT UPC IN ONE COLUMN BY LIKE NUNBERS

So sort them. What's the problem?

--- "PAUL" wrote:
I WOULD LIKE TO SORT UPC, ALL IN ONE COLUMN, SO THAT ONLY UPC S WITH THE SAME ONES WOULD BE TOGETHER.
00000000001111187184
00000000001121000660
00000000001380015172
00000000001540085186
00000000001540086412
00000000002100067840
00000000002100067846
00000000002100067916
00000000002100067922
00000000002100068347
00000000001111187176
00000000001111187184
00000000001121000660
00000000001380015172
00000000001540085186

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