# Excel sorting question?

**URL:** <https://boards.straightdope.com/t/excel-sorting-question/662236>\
**Category:** Factual Questions\
**Created:** [June 30, 2013, 2:23am UTC](https://boards.straightdope.com/t/excel-sorting-question/662236 "2013-06-30T02:23:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio107](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@antonio107](https://boards.straightdope.com/u/antonio107)\
**Post date:** [June 30, 2013, 2:23am UTC](https://boards.straightdope.com/t/excel-sorting-question/662236/1 "2013-06-30T02:23:54Z")

</div>

I’m coordinating a project among several people, sorting through data on a response sheet. Multiple rows correspond to a single response sheet number. So, for Example, "Response 1521"would encompass 15 rows of data. I wanted to sort them, and have all the rows show up in the right place. So in the first column, I put “1521(1),” “1521(2)” etc.

Problem is, 1521(10) and 1521(11) come up before 1521(2). Which I didn’t want it to, thus the brackets. Is there a better way to do what I’m trying to do? I’m clearly in way over my head.

---

<div class="post-metadata">

**Author:** ![Giles](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/giles/32/60_2.png) [@Giles](https://boards.straightdope.com/u/Giles)\
**Post date:** [June 30, 2013, 2:31am UTC](https://boards.straightdope.com/t/excel-sorting-question/662236/2 "2013-06-30T02:31:53Z")

</div>

Instead of “1521(1),” “1521(2)” etc., use “1521(01),” “1521(02)” etc. (That is, add a leading zero so that all the numbers are the same length.)

---

<div class="post-metadata">

**Author:** ![antonio107](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@antonio107](https://boards.straightdope.com/u/antonio107)\
**Post date:** [June 30, 2013, 2:35am UTC](https://boards.straightdope.com/t/excel-sorting-question/662236/3 "2013-06-30T02:35:56Z")

</div>

> [@Giles](#):
>
> Instead of “1521(1),” “1521(2)” etc., use “1521(01),” “1521(02)” etc. (That is, add a leading zero so that all the numbers are the same length.)

:smack:

Yeah…that’s a good idea.

I’ll…see myself out now. Thanks.

---

<div class="post-metadata">

**Author:** ![JWT\_Kottekoe](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@JWT\_Kottekoe](https://boards.straightdope.com/u/JWT_Kottekoe)\
**Post date:** [June 30, 2013, 2:41pm UTC](https://boards.straightdope.com/t/excel-sorting-question/662236/4 "2013-06-30T14:41:02Z")

</div>

Alternatively, add another column for the sequence number. Then sort first on the sequence number, and then on the response sheet number.
