Excel sorting question?

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.

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.

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